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)
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)