Re: query problem in 7.2.1: serious planner issue

On Thu, 4 Jul 2002 terry@greatgulfhomes.com wrote:

 > I cannot sort on a field that I join across tables.  Here are the examples:
 >
 > If I do this:
 > SELECT offers.lot_id, lots.project_id
 > FROM offers, lots
 > WHERE offers.lot_id = lots.lot_id
 >   AND ...
 > UNION
 > SELECT offers.lot_id, lots_deleted.project_id
 > FROM offers, lots_deleted
 > WHERE offers.lot_id = lots_deleted.lot_id
 >   AND ...
 > ORDER BY lot_id

   ORDER BY 1

Where the number indicates the position of the column in the
resulting table

Regards Herbie
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                                  http://www.thinx.ch
The content management company.         Visit http://www.contentx.ch
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~