Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Relationships between tables.
Message
 
À
31/01/1999 16:30:55
Marcelo Codino
Mystic & Faith - Sistemas -
Buenos Aires, Argentine
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00182313
Message ID:
00182315
Vues:
11
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform