UNION query in MSDE

Y

Yanto

How to create the UNION Query in MSDE? in view or store procedure ? if
possible please give any sample.
TIA

Yanto
 
T

TC

I imagine (but am not certain) that it would be like any other SQL UNION:

SELECT f1, f2 ...
FROM Table1
UNION
SELECT c1, c2 ...
FROM Table2
UNION
....

No?

HTH,
TC
 
Top