How to populate a table with data from maultiple tables for different columns when there is no relationship between the tables.
I created a new table and need to import data for column A-F from table1, column G-H from table2 and column I from table 3 and there is no relationship between the 3 tables.
I have created FKs in the new table for with Table 1, 2 and 3.
Can I use multiple select statements for insert into?
Thanks,
Blyzz