>Hi all,
>
>I have two tables, both are relationed.One of this have Clients and the other Pays of each client.The relation is (One-To-Many).The question is how can I know about those clients that have not pay.In other words all those records that have not any movement in the Client´s table.I want to extract those records in a query list.
>
>TIA

If you need just a list you can do SQL SELECT like:

SELECT * FROM clients ;
WHERE clients.client_code NOT IN (SELECT client.code from pays)