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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Impossible SQL query?

Re: Impossible SQL query?

From: Scott <Scott.Mattes_at_gmail.com>
Date: 5 Oct 2005 07:06:30 -0700
Message-ID: <1128521190.378014.99320@o13g2000cwo.googlegroups.com> 





I thought I understood.  Did you try it?



The first (select) gets all begins and gives them a number, and the
second gets all ends and gives them a number, then the outer select
joins them by number. The last line should have said '-- and a.id is
not null' and might not be needed.
Received on Wed Oct 05 2005 - 09:06:30 CDT












Original text of this message













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