如何实现对5个远程数据库的链接查询????
有五个远程结构一致的数据库,想对其中的几张表进行查询,在一个库中的查询为:
Select Bas007.M_id,Bas007.M_nm,Bas007.M_BrNm,Str001_Ia.I_da,Str001_Ia.I_no,
Str001_Ib.I_am,Str001_Ib.I_pr,Str001_Ib.I_am * Str001_Ib.I_pr AS hjje,Bas012.S_Sn,Bas008.E_Nm,
B.I_DaB,B.I_No,B.I_pr,C.S_Sn,D.E_Nm,Bas007.M_MaxPr,Bas007.M_MinPr,Str001_Ib.I_pr-B.I_pr,Str001_Ib.I_am * (Str001_Ib.I_pr-B.I_pr)
From Str001_Ia Left Outer Join Str001_Ib ON Str001_Ia.I_no = Str001_Ib.I_no
Left Outer Join Bas007 ON Str001_Ib.M_id = Bas007.M_id
Left Outer Join Bas012 ON Str001_Ia.S_id = Bas012.S_id
Left Outer Join Bas008 ON Str001_IA.E_Cg = Bas008.E_id
Left Outer Join Str001_IB B On Str001_Ib.I_LastIno=B.I_No And Str001_IB.M_ID=B.M_ID
Left Outer Join Str001_Ia A On B.I_NO =A.I_No
Left Outer Join Bas012 C On A.S_id =C.S_id
Left Outer Join Bas008 D On A.E_Cg =D.E_id
where Str001_Ia.I_da between '2008-06-08' and '2008-06-11'
Order By Str001_Ib.I_am * (Str001_Ib.I_pr-B.I_pr) Desc
如何实现,对5个库的链接查询?(将远程5个数据库中需要的表合并,查找出满足条件的项)