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)
