Thanks for the help - I can run this in both SQL and Crystal correct?
I am getting the following error in my SQL query:
Server: Msg 8157, Level 16, State 1, Procedure orders, Line 3
All the queries in a query expression containing a UNION operator must have the same number of expressions in...