Hi,
INSERT INTO table1 (supid, paid)
VALUES ( (SELECT supid FROM def_1 WHERE id IN (SELECT id FROM def_2)),
(SELECT paid FROM def_1 WHERE id IN (SELECT id FROM def_2))
This code returns more than 1 value, teherefore i can not execute it. Is there any other way to do it?
Thanks