>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 ? Is it correct ?

The code you posted seems to work, whats wrong?