Unanswered: How do you create a UNION query with the WHERE and ORDER BY clause.
I have try running a UNION query with only the where clause and it works but unable to get the query to work with the WHERE and ORDER BY clause in the query at the same time. What would be the problem?
Select mailnum As ID, maildesc as Description
Order By mailDate
Select shippingnum As ID, shippingdesc as Description
Order By shippingDate