Posted by Rob Shepherd on 10/03/05 17:10

Dear sql'ers

I have two tables for incoming and outgoing transactions

each has a date-time field.

How would I go about ordering a result set by date-time when selecting rows from
both tables.

I.e. I would like to produce an ordered list of transactions by date from both
tables without doing two queries and sorting the results externally.

Many thanks for any inspiration

Rob

--
Rap it up for the common good
Let us enlist the neighbourhood
It's OK, I've overstood
This is a wordy rappinghood. OK, bye.

Tomtomclub, 1980.

[Back to original message]