JOIN

[annub]

Can i join tables from different server. I am trying to do something like this. Gives me error.

select e.jobnumber,
baandb.dbo.ttisfc001201.t_pdno,
baandb.dbo.ttisfc001201.t_mitm,
baandb.dbo.ttiitm001201.t_dsca
from dfb_erp.baandb.dbo.ttisfc001201 ,
dfb_erp.baandb.dbo.ttiitm001201 ,
emplhrdtltest e
where baandb.dbo.ttisfc001201.t_mitm = baandb.dbo.ttiitm001201.t_item
and baandb.dbo.ttisfc001201.t_pdno = e.jobnumber

baandb - Database
DFB_ERP - different server

 

[JayKusch]

select e.jobnumber,
sfc.t_pdno,
sfc.t_mitm,
itm.t_dsca
from dfb_erp.baandb.dbo.ttisfc001201 as sfc,
dfb_erp.baandb.dbo.ttiitm001201 as itm,
emplhrdtltest as e
where sfc.t_mitm = itm.t_item
and sfc.t_pdno = e.jobnumber

If that does not work ... what is the error that is produced?

Thanks

J. Kusch