Toad World® Forums

No result for SQL with Union(all), Minus


Dear Sir,

when I run a SQL with union (all) and Minus in ver 6.0.  There is no data display in grid not like ver 5.5.


Kent Lai


Hi Kent,
Nice catch.
The problem is due to the brackets. Our parser can’t recognize the statement unless it begins with a keyword. As a workaround, you can insert SELECT * FROM at the beginning, it will work. The problem will be addressed in the next release.