Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relationships between tables.
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00182313
Message ID:
00182322
Views:
13
>>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)

Sorry, I meant
SELECT * FROM clients ;
WHERE clients.client_code NOT IN (SELECT client_code from pays)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform