Menu ▾ ▴

#54 Some statements don't parse

open
nobody
None
5
2010-02-23
2010-02-23
Anonymous
No

The statement below doesn't parse by the SQLParser for Delphi:

select sum(NrCount) as NrCount
from (
select count(1) as NrCount
from tblTable1 t
where t.mycol = 0
UNION ALL
select count(1) as NrCount
from tblTable2 t2
where t2.mycol = 0
) as idTbl

Discussion


Log in to post a comment.