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: How to select overlap records?

Re: How to select overlap records?

From: Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid>
Date: 2000/07/12
Message-ID: <06a5b008.1af10a7c@usw-ex0105-037.remarq.com>#1/1

Where's Joe Celko when you need him?
My potential hack appears to work:

select a.*, b.*
from table1 a, table2 b
where

     a.from_len between b.from_len and b.to_len and (a.rowid <> b.rowid)

-Ethan

http://www.freetechnicaltraining.com/article_10.htm http://www.gnumetrics.com


Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 12 2000 - 00:00:00 CDT

Original text of this message

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