not match data

B

Brad

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
 
D

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
 
Top