4 Replies Latest reply: May 6, 2012 9:16 PM by Hemant K Chitale RSS

    INSERT INTO SELECT with subquery

    932957
      Can I do something like this??

      INSERT INTO tbl1
      SELECT A,B,C,D,ID,(SELECT KEY FROM TBL2 WHERE X=ID),E,F FROM TBL3;

      Can I use same column ID in 2 places as above?