I'm working with SQL server 2000 (upsized from MS Access 2000) and I've been able to reconcile all my SQL differences but one. I build a fairly complex recordset that consists of a UNION from two different SELECT statements. It ends up looking like this:
Table1 WHERE Col1='aaa' ORDER BY Col1 ASC, Col2 ASC
Table2 WHERE Col5='bbb'
When my ASP was hooked into Access, that statement executed fine. However, SQL server returns an error that says "Invalid syntax near keyword UNION". I've tried surrounding the SELECT statements ...