question

Wiz avatar image
Wiz asked

Combining 9 tables with 2 columns each

I have 9 tables. All have 2 columns. i want to combine all the 9 tables into one, with the columns from the 9 tables as columns in the new table.
tablescombinations
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Dave_Green avatar image
Dave_Green answered
Assuming you want to just concatenate the tables, you can use the [UNION ALL][1] operator to do this: SELECT a,b FROM Table1 UNION ALL SELECT a,b FROM Table2 -- etc... [1]: https://msdn.microsoft.com/en-us/library/ms180026.aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Wiz avatar image Wiz commented ·
thanks Dave
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.