Quote:
Originally posted by jayeshdba
I want to do a query using union operator and retrieve data from multiple tables (which fullfills condition to use union operator) ,
Just so you are not confused - you certainly do not need to be coming from multiple tables to use the UNION operator. Since you are confused on this point, I'm little worried that you may be thinking that you need the UNION when you don't. If you give us a little more info about the query, or the query itself, we could probably help you more.