Page 1 of 1

Re: SELETC...INSERT plus a String

Posted: Fri Aug 17, 2012 11:28 pm
by NigelRen
Sounds like you want to use an insert ... select type statement - ... elect.html.

You should be able to work out from their example of

Code: Select all

INSERT INTO tbl_temp2 (fld_id)
  SELECT tbl_temp1.fld_order_id
  FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;
what this should be as you already have most of it.