Appending non-duplicate records

[achillese]

Hi,

I would like some assistance on this append query. If I remove the INNER JOIN, the link source table, and just add the fields from the source table the query works. Otherwise, the query below doesn't work.

Is it because i link two fields? or
Is is because in my WHERE CLAUSE i have two conditions, one of which from another table?

Please help!!!

INSERT INTO [TargetTable] ( [Batch Number], [Activation Dealer], IMEI, [Activation Dealer Name], [Material Code], [Material Description], [Order], [Invoice Number], [Shipment Date

FROM [SourceTable] INNER JOIN [TargetTable] ON ([SourceTable].[Batch Number] = [TargetTable].[Batch Number]) AND ([SourceTable].IMEI = [TargetTable].IMEI)

WHERE ((([SourceTable].[Batch Number])>="00316") AND (([SourceTable].IMEI)<>[TargetTable]![IMEI]));

 

[lupins46]

You have conflicting conditions.
The join requires equality for IMEI values but the 'where' clause requires them to be different.

Only one of these can be true, so you will never select any records.