How to create a table in my database?

Transact-SQL
1

hi, so i exported 3 similar CSV files from my sharedrive to my database called datalab.after exporting all 3 csv files to my data lab, i merged the three files using a union function

select "column1","column2","column3" from "datalab"." table1"

union

select "column1","column2","column3" from "datalab"." table2"

union

select "column1","column2","column3" from "datalab"." table3";

now i like to create that table and insert it into my data lab and call that table "COMBINED TABLE".

How do i create or insert that table in my datalab.

Thanks

2

image
image.png724×536 22.6 KB

1 Like
3 
SELECT * INTO [COMINED TABLE] FROM (
select "column1","column2","column3" from "datalab"." table1"
union
select "column1","column2","column3" from "datalab"." table2"
union
select "column1","column2","column3" from "datalab"." table3") x;
4

thanks