Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Grigore,
>Please, can anyone tell me how can I simulate INTERSECT clause of an SQL interogation?
SELECT * FROM Table1 UNION Select * FROM Table2 INTO CURSOR x
SELECT * FROM x UNION ALL SELECT * FROM Table3 INTO CURSOR y
SELECT * FROM Y GROUP BY allfields... HAVING COUNT(*) = 2
would produce the desired result if in each table there is an existing primary key (so multiple exact same records cannot exist in one table).
I have not tried it, but you might be able to combine statement 2 and 3 to:
SELECT * FROM x UNION ALL SELECT * FROM Table3 GROUP BY allfields... HAVING COUNT (*) = 2
Hope this helps
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only