Struggling with my SQL again,
I am loading new data into tblPrices from tblPasteForLoad
The tblPrices table has a compound key consisting of SupplierID and ProductCode.
INSERT INTO tblPrices (SupplierID, ProductCode)
SELECT SupplierID,ProductCode from tblPasteForLoad
tblPasteForLoad.SupplierID & tblPasteForLoad.ProductCode
NOT EXISTS IN tblPrices
Hopefully the above 5 lines of pseudo SQL will indicate the SQL I actually require.