Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Union select
Message
From
22/06/2000 16:54:22
 
 
To
22/06/2000 16:28:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00383252
Message ID:
00383445
Views:
16
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform