Posted by Rob Shepherd on 10/14/77 11:28

Bob Stearns wrote:
> 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

Thanks very much

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.

• Next in forum: Pear::DB and WHERE clause param in PS
• Prev in forum: Re: Birthday SQL Problem
• Thread view: Re: sorting two result sets by common type field

[Reply to this message]