同库操作select a.列名1,b.列名2,a.列名3 from 表名1 as ajoin 表名2 as bon a.关联字段=b.关联字段
不同库操作select a.列名1,b.列名2,a.列名3 from 库名1.dbo.表名1 as ajoin 库名2.dbo.表名2 as bon a.关联字段=b.关联字段
2张表以上的多表连接：先两张连接再与第三张连接，依次下去，如select a.列名1,b.列名2,a.列名3 from 表名1 as ajoin 表名2 as bon a.关联字段=b.关联字段join 表名3 as con a.关联字段=c.关联字段
转载于:https://www.cnblogs.com/jieran-zero/p/6282646.html
