Not sure I understand this syntax: (select count(*) cnt from T2) t2_cnt, (select maxrows from T1) max_t1 Yes it's defining new tables it's a shortcut for: (select count(*) as cnt from T2) as t2_cnt, (select maxrows from T1) as max_t1
Not sure I understand this syntax: (select count(*) cnt from T2) t2_cnt, (select maxrows from T1) max_t1 Yes it's defining new tables it's a shortcut for: (select count(*) as cnt from T2) as t2_cnt, (select maxrows from T1) as max_t1