Creating a Join Query

[gutenberg]

I am trying to create a join query that will combine 3 different queries called Q_OrderDelAlt, Q_OrderDtl, and Q_OrderHdr.

The 3 different tables I want to use are called: OrderDetail, OrderHeader and OrderDeliveryAlt.

Each table has the same field called OrderNu

Here is the SQL for the join query:

SELECT OrderDetail.OrderNu,
FROM OrderDetail
WHERE (((OrderDetail.OrderNu)=[Enter the OrderNu:]))
ORDER BY OrderDetail.OrderNu
Union
SELECT OrderHeader.OrderNu,
FROM OrderHeader
WHERE (((OrderHeader.OrderNu)=[Enter the OrderNu:]))
ORDER BY OrderHeader.OrderNu


UNION SELECT OrderDeliveryAlt.OrderNu,
FROM OrderDeliveryAlt
WHERE (((OrderDeliveryAlt.OrderNu)=[Enter the OrderNu:]))
ORDER BY OrderDeliveryAlt.OrderNu;

I get this error message when I run the Join query:



Does anybody know how to make this join query work properly?

[pbaldy]

The commas at the end of the SELECT clauses will cause an error. You only want the last ORDER BY.