DB2 9.7中merge into with as问题

你是指下面用法通不过吗?

using (

  with t as (...)

  with t2 as (...)

  select ... from t,t2 ...

)

我测试了一下,是有问题, 如果这种场景不多, 看能否用VIEW的方式绕过去

create view myview1 as

with t as (...)

  with t2 as (...)

  select ... from t,t2 ...

然后在MERGE中

using (

select ... from myview1

)