单句执行没错
with a as (select *from PRODUCTION.PRODUCT limit 3) select * from a;
多句with as应该怎么写呢?
with tempA as (select * from t1), tempB as (select * from t2) select * from tempA,tempB where ....
with tempA as (select * from t1),
tempB as (select * from t2)
select * from tempA,tempB where ....