SQLite Forum

Can this SQL be simplified?
Login
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