table from linked DB in from clause?

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:46:42 CDT