RE: anyone know how to do a join where the data can be different

select <col>
from tab1, tab2
where tab1.id <http://tab1.id/>  = tab2.id <http://tab2.id/> 
and tab1.datefield between tab2.datefield - 5/86400 and tab2.datefield +
5/86400
 
(assuming my math is correct on seconds in a day!)
 
-Jackie
 
Jackie D. Brock
Database Specialist - Systems Evaluation
CableLabs(r)
858 Coal Creek Circle
Louisville, CO 80027
Email: j.brock@xxxxxxxxxxxxx <mailto:j.brock@xxxxxxxxxxxxx> 
303-661-3347
 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rick Ricky
        Sent: Wednesday, May 14, 2008 12:32 PM
        To: oracle-l@xxxxxxxxxxxxx
        Subject: anyone know how to do a join where the data can be
different
        
        
        I have two different data sets. They come from two different
feeds.  

        I have an ID field that I can join on that is the same in both.
However, I have a date field in each. Here is the catch, the dates can
be up to 5 second apart. 

        So I have

        select <col>
        from tab1, tab2
        where tab1.id = tab2.id
        and tab1.datefield is with in 5 seconds of tab2.datefield

        anyone know a way to do this without a lot of complex pl/sql?

Other related posts: