OOps! That's better. Qualified which ClientID to return.
>John's way will work great. Another way to accomplish this using joins is:
>
>
>CurrentMonth = 9
>CurrentYear = 2000
>
>SELECT Clients.clientid ;
>FROM clients ;
>INNER JOIN Payments ON Clients.ClientID = Payments.ClientID ;
>WHERE Payments.Month == CurrentMonth AND Payments.Year == CurrentYear ;
>
>
>>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 ?
Marty Smith, CSQE