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 ?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement