Hi guys,
I got the test1 table with three columns:
id(BIGINT) - j_id(BIGINT) - comments(CHARACTER VARYING)
This needs to be done 180 times:
INSERT INTO test1 (id,j_id,comments) VALUES (default,123321,'test-1 - comments');
INSERT INTO test1 (id,j_id,comments) VALUES (default,123322,'test-1 - comments');
INSERT INTO test1 (id,j_id,comments) VALUES (default,123323,'test-1 - comments');
INSERT INTO test1 (id,j_id,comments) VALUES (default,123324,'test-1 - comments');
INSERT INTO test1 (id,j_id,comments) VALUES (default,123325,'test-1 - comments');
However, I have to get j_id from another table:
select j_id from test2 WHERE customer_id = 88897
17012651
17012601
16623374
16808986
16843879
16808794
16870199
16870488
16870443
16870403
Example of what I need:
INSERT INTO test1 (id,j_id,comments) VALUES (default, 17012651,'test-1 - comments');
INSERT INTO test1 (id,j_id,comments) VALUES (default, 17012601,'test-1 - comments');
INSERT INTO test1 (id,j_id,comments) VALUES (default, 16623374,'test-1 - comments');
INSERT INTO test1 (id,j_id,comments) VALUES (default, 16808986,'test-1 - comments');
INSERT INTO test1 (id,j_id,comments) VALUES (default, 16843879,'test-1 - comments');
etc...
How can I do that? If the customer_id is the same for all those 180 rows?
Cheers
Patrick