外联接 LEFT OUTER JOIN,其中关键词OUTER是可选的。LEFT JOIN是表示列出左表所有记录,右表没有匹配的列使用NULL作为占有符。
演示例子,两张表来自http://www.cnblogs.com/insus/articles/1977561.html这里的[Machine]表和[Job]表。
例子演示,取得所有分配有工单和没有分配工作单的机器记录:
View Code
SELECT
M.
[
M_Id
]
,J.
[
J_Id
]
,
[
MachineName
]
,
[
LineName
]
,
[
JobNumber
]
,
[
J_Date
]
FROM
[
dbo
]
.
[
Machine
]
AS
M
LEFT OUTER JOIN -- OUTER关键词是可选的。
[ dbo ] . [ Job ] AS J
ON (M. [ M_Id ] = J. [ M_Id ] )
LEFT OUTER JOIN -- OUTER关键词是可选的。
[ dbo ] . [ Job ] AS J
ON (M. [ M_Id ] = J. [ M_Id ] )
执行结果: