有两个字段完全不一样的数据库,怎么样用一句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
---------------------------------------------------------------
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
浙公网安备 33010602011771号