Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL question
Message
 
 
À
06/08/2009 04:29:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Divers
Thread ID:
01416401
Message ID:
01416439
Vues:
71
>
>	select S.* ;
>		from Schnaps S, ;
>			( ;
>				select c3 ;
>					from Schnaps ;
>					group by  1 ;
>					having ( count( distinct c1 + c2 ) > 1) ;
>			) AA ;
>			where	( S.c3 == AA.c3 )
>		
>
>
>

Unfortunately, this would not give us only error cases - I just thought of the same SQL. You don't need to join here. This would give all C3 cases even when a/b combination is the same - I don't see a simple way to separate them - need to think.

UPDATE. Actually, it may be simple - we just need to add min(a) and min(b).
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform