How to join three tables in a single table

Question

Hi How to join three tables in a single table in sql server ?

John Penn · Answer

If you're referring to three tables with similarly-structured data that need to appear as one table then a UNION query might be what you need: select abc from table1 union select def from table2 union select ghi from table3 Note that UNION will automatically remove duplicate rows from the resultset -- if you want the duplicates use UNION ALL instead.