Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECTing records which are NOT DISTINCT
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00095346
Message ID:
00095436
Vues:
21
Paul,
Take a look at the IN clause. You may be able to formulate your query by doing
something like this

Select * from table where pkey not in ;
(select col1, col2, col3 from table group by 2,3)

This should return all records not selected in the 2nd query.

Let me know if that works for you..


Thanks,
Rod
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform