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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the result of Store Proc. in VIEW (MSDE) 0
UDF on query 2
Column Heading on Crosstab Query 5
union query with "unique" and "is not null" values 1
Incone & Expenses Statement 0
Populating a null field in record with previous record value 0
SUM in a UNION query 2
I can't run the paramters I need in Microsoft Query 1

Top