Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to select overlap records?
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