Hi,
i am trying to insert multiple table values into one table. i am not get the result. here is my code.
CREATE TABLE one (ID INT, col1 varchar(100))
CREATE TABLE two (ID INT, col2 varchar(100))
CREATE TABLE main (ID INT, col1 varchar(100), col2 varchar(100))
INSERT INTO one (ID, col1) VALUES (1, 'A')
INSERT INTO one (ID, col1) VALUES (1, 'B')
INSERT INTO one (ID, col1) VALUES (1, 'C')
INSERT INTO one (ID, col1) VALUES (1, 'D')
INSERT INTO one (ID, col1) VALUES (1, 'E')
INSERT INTO two (ID, col2) VALUES (1, 'F')
INSERT INTO two (ID, col2) VALUES (1, 'G')
INSERT INTO two (ID, col2) VALUES (1, 'H')
INSERT INTO two (ID, col2) VALUES (1, 'I')
INSERT INTO two (ID, col2) VALUES (1, 'J')
and my insert statement is
INSERT INTO main (ID, col1, col2)
SELECT one.ID, one.col1, two.col2 FROM one
LEFT OUTER JOIN two ON one.ID = two.ID
can you give me a solution..
i want the result like this:
ID Col1 Col2
1 A F
1 B G
1 C H
1 D I
1 E J
Thanks