Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL EXISTS clause
Message
De
16/10/2002 15:12:45
Mike Sue-Ping
Cambridge, Ontario, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00711792
Message ID:
00711911
Vues:
12
Thanks Martin...The first one did the trick! I didn't try the second command, but, I'm sure that it would also work ;)

Mike


>Hi Mike,
>
>
>* Table_A.PK =Table_B.PK
>SELECT * FROM Table_A WHERE NOT EXISTS ( SELECT Table_B.PK FROM Table_B WHERE Table_B.PK=Table_A.PK)
>
>* OR
>SELECT * FROM Table_A WHERE NOT Table_A.PK IN ( SELECT Table_B.PK FROM Table_B WHERE Table_B.PK=Table_A.PK)
>
>
> MartinJ
>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform