insert values from one table to another table

[nimi]

Hi...
I want to insert particular field values from one table to another but only if they do not already exist in that table.
How to do that?

[rekha]

You have to put the condition to check for duplicates in the select query.

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;