anyone know how to do a join where the data can be different
- From: "Rick Ricky" <ricks12345@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 14 May 2008 14:31:39 -0400
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:
