currentmonth = 9
currentyear = 2000

Select clientid
From clients
Where clientid Not In (Select clientid From payments where month = currentmonth and year = currentyear)

Yes, JVP posted something technical.

No, Hell has not frozen over yet...but I am working on it...


< JVP >


>Hi all,
>
>I have two tables, both are relationed,(one-to-many).One contains clients and the other payments.Now, how can I search clients that haven´t yet paid in the current month and in the current year the monthly fee ?