Everything works fine with the Query until I put in the "Order By" clause. I receive the following Error Detail: " Kindly ensure that the table name you have specified is in the query scope.".

=======

SELECT "Catagory", "Agent", "Passenger", "Booking Number", "Travel Date"

FROM "August 2011"
WHERE "Agent" = 'JOHN'
UNION
SELECT "Catagory", "Agent", "Passenger", "Booking Number", "Travel Date"

FROM "September 2011"
WHERE "Agent" = 'JOHN'
ORDER BY "Travel Date"

=======

So, what am I doing wrong??? Any help would be greatly appreciated. Thanks!