Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL question
Message
De
06/08/2009 08:59:24
 
 
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:
01416440
Vues:
68
>>
>>	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.

Yes, and start reading the question first
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform