Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Differentiating results of SELECT query

Re: Differentiating results of SELECT query

From: newbert <logangreen_at_gmail.com>
Date: 13 Dec 2006 01:35:00 -0800
Message-ID: <1166002500.802228.36140@79g2000cws.googlegroups.com> 





Alright, I found a solution to my own problem.  This works, but it is
very slow.  Does anyone has a more graceful solution?



SELECT locations_s.address as start_address, locations_e.address as
end_address


FROM rides, locations locations_s, locations locations_e
WHERE locations_s.location_key = rides.start
AND locations_e.location_key = rides.end 
AND rides.ride_key = '8'
Received on Wed Dec 13 2006 - 03:35:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US