Marcelo

assuming you have a client table and a payment table

SELECT Client.Cl_ref FROM client ;
WHERE Client.Cl_ref NOT IN (SELECT cl_ref FROM payment)

That would give you clients who had never ever paid so you need to add some dates to the selection from the payment table to restrict it to your desired period .



Nick Mason