On Fri, 31 Aug 2001, Jeff Davis wrote:
> Whew... a little complex. I think I know what you are trying to do.
What's wrong with something like
select airport1.name as departure, airport2.name as arrival from
destination, airport as airport1, airport as airport2 where
airport1.airport_id=airport_dep_id and
airport2.airport_id=airport_arr_id;
?
Maybe I'm overlooking something, but it seems pretty straightforward to
me.
--
Alvaro Herrera (<alvherre[(at)]atentus(dot)com>)