Menu

#39 union and bracket cause error

open
nobody
None
5
2004-08-12
2004-08-12
johnzeng
No

If post this SQL to TgaAdvancedSQLParser and parse it
will cause error.
cause error SQL:
(select aTable_GUID as GUID from bTable right outer join
aTable on bTable_ZBGUID=aTable_GUID)
union all
(select cTable_GUID as GUID from dTable right outer join
cTable on dTable_ZBGUID=cTable_GUID)

but if omit the bracket ,that all work well.

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.