not match data

[Guest]

File "A" had all the active contracts as of year-end
File "B" has all active contracts as on right now.

I want a query that will show all contracts issues after year-end - contract
numbers will not to be sequential. By this I mean that if the last contract
number at year-end was 12345678 - we may add a contract number 12345600 in
the current calendar year.

Said differently I want a query only when the contract is on File "B" but
not on File "A".

If have tried the not matched query command - but haven't be successful

 

[Douglas J. Steele]

The unmatched query wizard should be able to do it for you: that's exactly
what it's for.

The SQL should be something like:

SELECT FileB.ContractNb
FROM FileB LEFT JOIN FileA
ON FileB.ContractNb = FileA.ContractNb
WHERE FileA.ContractNb IS NULL

 

[Guest]

Thanks for providing the SQL - found out what my problem was.