有答案马上结贴 SQL查询多个数据库

有两个字段完全不一样的数据库,怎么样用一句SQL语句来将两个数据库里的数据全部查询出来啊?
---------------------------------------------------------------

sql="select a.a,a.a1,b.b,b.b1 form a,b where 条件"
---------------------------------------------------------------

Select * from server1.database1.dbo.table1 as A ,
server2.database2.dbo.table2 as B
where xxxxxxx

Published At
Categories with Web编程
comments powered by Disqus