Click here to Skip to main content
15,946,342 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?

1 solution

Join the 2 tables with a union:

select Column1, Column2 from Table1
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