Click here to Skip to main content
15,938,218 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi every one,
I need to combine columns/results of two separate select statement, how can i do so plz help ....
"Thanking you"
Posted
Comments
[no name] 20-Jul-12 8:29am    
Okay.... so go ahead and do it.

Hard to find out what you need.
A UNION ALL will add the rows received from each statement, e.g.
SQL
SELECT * FROM TABLE1
UNION ALL
SELECT * FROM TABLE2
 
Share this answer
 
SQL
  select T1.*,T2.* from tableT1,Table2 T2


or 

select * from  table1
union all
select * from table2

or

select  Field1 from table1
union
select field2 from table2
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900