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

From: Rick Ricky <ricks12345_at_gmail.com>
Date: Wed, 14 May 2008 14:31:39 -0400
Message-ID: <81f4c0700805141131tbbbc364n16b5a55749e8eca6@mail.gmail.com>


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?

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 14 2008 - 13:31:39 CDT

Original text of this message