Click here to Skip to main content
15,949,741 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how add two different tables in one grid i'm getting those tables using stored procedure?
Posted

1 solution

Join the 2 tables with a union:

select Column1, Column2 from Table1
union
select Column1, Column2 from Table2


You'll need to take care of sorting and making sure that both tables have the same number of columns.

You can add dummy columns to the table with fewer columns as:

select Column1, null 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