Re: query problem in 7.2.1: serious planner issue

On Thu, 4 Jul 2002 terry(at)greatgulfhomes(dot)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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~