I have created the following SQL query. This is fine on initialising the table but for succesive INSERTS, I need to only add records where the combined PostCode fields do NOT already exist in the dbo.MER_Consignee_PostCodes
(PostCode_1 and PostCode_2 are the Primary Key)
INSERT INTO dbo.MER_Consignee_PostCodes
SELECT DISTINCT PostCode_1,
Succesive entries must have the Previously_Checked
field set to '0'.
How do I do this within a query?
Thanks in advance,
A Northern Soul