Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relationships between tables.
Message
 
To
31/01/1999 16:30:55
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentina
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00182313
Message ID:
00182315
Views:
10
If I understand what you're asking you want to find all records in the clients table that don't have a corresponding record in pays. Assuming the tables are related on ClientID, you could use this query:
SELECT * ;
   FROM clients ;
   WHERE clients.ClientID NOT IN (SELECT ClientID FROM pays)
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform