Posted by Bob Stearns on 10/14/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

• Next in forum: Re: can anyone help ?
• Prev in forum: sorting two result sets by common type field
• Thread view: Re: sorting two result sets by common type field

[Reply to this message]