query question

  • Thread starter Thread starter golan
  • Start date Start date
G

golan

hi, i have 2 tables contract and payment under payment i have field
pay_for(date).
i want to see all contracts that dont pay for example 10/08.
 
hi, i have 2 tables contract and payment under payment i have field
pay_for(date).
i want to see all contracts that dont pay for example 10/08.
Click to expand...

a NOT EXISTS query will do this:

SELECT Contract.*
FROM CONTRACT
WHERE NOT EXISTS
(SELECT ContractNo FROM Payment
WHERE Payment.ContractNo = Contract.ContractNo
AND Payment.Pay_for BETWEEN #10/1/08# AND #10/31/08#)
 
Back
Top