simple insert into without dups syntax (?)

[markjkubicki]

trying to write a simple SQL to add records from a source table <exp_manufacturers> to a target table <manufacturers> without duplicating records in <manufacturer>; and (I'm sure it's obvious... but) I'm stuck in syntax error...


insert into Manufacturers (ManufacturerName,"Web Site", TelephoneNumber, Email, PrimaryCatagory) select Manufacturer, WebSite, TelephoneNumber, Email, PrimaryCatagory from (exp_manufacturers) where Manufacturers.ManufacturerName not in (exp_Manufacturers.Manufacturer from exp_Manufacturers);


many thanks in advance
mark

[Beetle]

Insert Into Manufacturers (ManufacturerName,"Web Site", TelephoneNumber, Email, PrimaryCatagory) Select Manufacturer, WebSite, TelephoneNumber, Email, PrimaryCatagory From exp_manufacturers Left Join Manufacturers On exp_manufacturers.Manufacturer = Manufacturers.ManufacturerName
Where Manufacturers.ManufacturerName Is Null

[markjkubicki]

thanks...

with a few minor adjustments... (ambigous refference to field names common to both tables)
perfect