Result Set Differentiation..!!

[Saurabh Arora]

Hi

We are trying to get the result sets as follows -

select (

select col1, col2, col3 from db.tbl where condition) as rsdb1 ,

(select col1, col2, col3 from db.tbl2 where condition) as rsdb2 ,

(select col1, col2, col3 from db.tbl3 where condition) as rsdb3 ,

(select col1, col2, col3 from db.tbl4 where condition) as rsdb4


after we get the results, we count the rows and display which has maximum count.


WHAT we were doing before -> get the count of all tables, then fire the query to get the RS. But the query written above gives the error as we can only select 1 column how is it possible to get the data from 4 tables into 1 query where we can differentiate the resultsets.