SQL Insert Question

[warrenk]

I am trying to insert records from tableA into tableB if the records do not exist in tableB.  Here is my sql statement...

 

INSERT INTO str_a1table2( `brands_url` , `brand_name` , `product_url` , `product_name` , `price` )

SELECT `str_a1table1.brands_url` , `str_a1table1.brand_name` , `str_a1table1.product_url` , `str_a1table1.product_name`

FROM str_a1table1

WHERE str_a1table1.brands_url <> str_a1table2.brands_url

AND str_a1table1.brand_name <> str_a1table2.brand_name

AND str_a1table1.product_url <> str_a1table2.product_url

AND str_a1table1.product_name <> str_a1table2.product_name

 

I keep getting syntax errors.  Any help greatly appreciated!

 

Thanks,

Warren

[artacus]

Think of the INSERT INTO and SELECT as two totally different statements. Well at least the select has to work on its own. You can't have table2 in your select because you haven't joined it. Get the Select part working and add the INSERT statement after that.