Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Union select
Message
De
22/06/2000 16:54:22
 
 
À
22/06/2000 16:28:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00383252
Message ID:
00383445
Vues:
15
There's one key if you're joining the 2 WHERE clauses of your SELECTS and that's parentheses.

SELECT...
WHERE (1st join condition) OR (2nd join condition)

Without the parens you'll get, .... who knows but it won't be what you want.

RE: # of students returned. By default, the UNION eliminates duplicate records. In my cursory review of the code, it seems as though the 2 WHERE clauses are mutually exclusive. But that may not be the case, and if you have a the same student-class-etc. returned in both SELECTs, you'll get only one record for both instances in the UNION.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform