Append Query - Only new Records

[pony08]

How can I modify the below code so that it only adds new records to AttributesTBL from ProductInformation-Consumer? Thx


INSERT INTO AttributesTBL ( Material )
SELECT [ProductInformation-Consumer].Material
FROM AttributesTBL INNER JOIN [ProductInformation-Consumer] ON AttributesTBL.Material = [ProductInformation-Consumer].Material;

 

[pr2-eugin]

How do you recognize that they are new records?

 

[pony08]

There will be records in ProductInformation_Consumer table that are not the Attributes Table.