sql跨数据库查询
http://niunan.javaeye.com/blog/387226
数据库1:AAA 数据库2:BBB
数据库名和表名之间放两个点
select * from [AAA]..TableA a inner join [BBB]..TableB b on a.AcountID = b.ClientID
注意:必须是单个Sql实例!
http://zhidao.baidu.com/question/87651354.html
Select TA.* From A.dbo.products TA join B.dbo.price TB On TA.P_Pid = TB.Pid Order By TB.Pri