Posted by Bob Stearns on 10/07/24 11:28

Rob Shepherd wrote:
> 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
>
The keywords you need are UNION and ORDER BY

[Back to original message]