been there, done that, didn't work
On Thu, 10 Mar 2005 15:37:30 -0500, David Wendelken
<davewendelken_at_earthlink.net> wrote:
>
> I would try this to see if you get a quick fix:
>
> select *
> from a
> ,(select * from b_at_site1 b, c_at_site1 c
> where b.col3 = c.col4
> ) bc
> where a.col1 = bc.col2
>
> >select *
> >from a, b_at_site1 b c_at_site1 c
> >where a.col1=b.col2 and
> >b.col3 = c.col4
> >
>
> That might cause the join in the remote database.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
--
Alfonso Leon
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 10 2005 - 15:29:32 CST
