Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INTERSECT
Message
From
04/05/2000 23:23:43
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
INTERSECT
Miscellaneous
Thread ID:
00366418
Message ID:
00366418
Views:
54
Hi,
I have a subquery which made use of UNION. Is there any INTERSECT equivalent SQL statement which can be used with UNION?

((select * from table1
UNION
select * from table2) INTERSECT
(select * from table3))


Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Next
Reply
Map
View

Click here to load this message in the networking platform