Hi,
> 2 DBs sitting on different machines, any idea of how
> to run the query?
>
> Select a.*, b.field1 from computernam.db1.table1 a,
> computername.db2.table1 b where a.fieldx = b.fieldx
>
> where computername is host for DB.
As far as I know, you cannot.
With regards,
Martijn Tonies
Database
Hi,
2 DBs sitting on different machines, any idea of how
to run the query?
Select a.*, b.field1 from computernam.db1.table1 a,
computername.db2.table1 b where a.fieldx = b.fieldx
where computername is host for DB.
regards
__
