Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need help with Select SQL
Message
From
30/04/1998 17:15:39
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00096128
Message ID:
00096138
Views:
17
>I'm just learning the wonders of the select command, so I apologize if this question is trivial.
>
>I have tables A, B, and C. I want to make a cursor of all the ID numbers in A that also appear in _either_ B or C. I think this can be done with select, but I'm not sure how.
>
>Thanks,

select distinct a.id from a,b,c where a.id = b.id or a.id = c.id

BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform