Y Yanto Nov 13, 2003 #1 How to create the UNION Query in MSDE? in view or store procedure ? if possible please give any sample. TIA Yanto
How to create the UNION Query in MSDE? in view or store procedure ? if possible please give any sample. TIA Yanto
T TC Nov 14, 2003 #2 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
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
