Advertisement

1 - 2 of 2 containing alltags:("SQL UNION Query") (0.001 seconds)
If I run the individual queries from the following union, i get the expected result.  However, if I run the union as is, I get an incorrect result.  Can anyone tell me why?  Also, the second query ...
Zones: SQL SyntaxDate Answered: 04/22/2007 Grade: A Views: 0
I am trying to get this query to work.. SELECT Q_Open_Orders_SO.ShipYear AS [Year] FROM Q_Open_Orders_SO UNION ALL SELECT Q_Shipped_Orders_AR.InvYear AS [Year] FROM Q_Shipped_Orders_AR; ...
Zones: SQL Reporting, MS Access, SQL SyntaxDate Answered: 05/12/2008 Grade: A Views: 0
  • 1