跨数据库查询两张表


select Table8.COLUMN1, Table8.Column2, Table8.COLUMN7 as TeaId, Table2.COLUMN10 from
(BJ_JW.dbo.Table8 as Table8 left join BJDB1.dbo.Table2 on
Table8.COLUMN16=Table2.COLUMN1)

原文地址:https://www.cnblogs.com/honghong75042/p/2341824.html