I have a query 'qrymainQuery' which has many subqueries
the statement Select * from qrymainQuery hangs
qrymainQuery is as follows
TABLE qry1
UNION TABLE qry2
UNION TABLE qry3
UNION TABLE qry4
UNION TABLE qry5
UNION TABLE qry6
qrymainQuery doesn't yield a result, but all the queries qry1 to qry6 yields results when running individually.
Can any body help in this issue. Thanks