Re: table from linked DB in from clause?

got it - in my haste I was using the connect string in the tnsnames rather than the one in dblinks!

***red face***

"Glen A Stromquist" <stromqgl_at_alpac.ca> wrote in message news:SiKA6.1659$Kd5.65095_at_news0.telusplanet.net...
> Thought this would be simple...
>
> I want to pull data from 2 tables in 2 linked db's, my query looks like
> this:
>
> select a.filed1, b.field2
> from table1 a, table2_at_db2 b,
> where a.field = b.field
>
>
> obviously I am approaching this wrong, whats the right way?
>
>
> thanks in advance
>
>
>
>
Received on Tue Apr 10 2001 - 15:56:36 CDT