Experts, I have the below APPEND query.
I am trying to APPEND to tblConsortium where tblAgreements_thisPrj.AgtI
D is NOT IN tblConsortium.AgtID
There are records that should be APPENDED but when I run it there are 0 records to be APPENDED.
What do you think is missing?
INSERT INTO tblConsortium ( AgtID )
gtID) Not In (SELECT [tblConsortium].[AgtID] FROM [tblConsortium])));