Toad World® Forums

No result for SQL with Union(all), Minus


#1

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.

Regards,

Kent Lai
moz-screenshot-9.jpeg


#2

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.

Thanks,
Roman