您要查找的是不是：
- A self-join can be an inner join or an outer join. 自联接可以是内部联接,也可以是外部联接。
- A type of outer join in which all rows from the left-most table in the JOIN clause are included. 一种外部联接,其中包括JOIN子句中最左侧表中的所有行。
- SELECT TOP 1 * FROM T1 LEFT OUTER JOIN T2 ON T1.Id = T2.ParentId ORDER BY T1.Id ASC . 版权申明：本站文章均来自网络，如有侵权，请联系028-86262244-215，我们收到后立即删除,谢谢！
- To include all sales persons in the results, regardless of whether they are assigned a territory, use an SQL-92 right outer join. 若要在结果中包括所有销售人员,不论是否为他们分配了区域,请使用SQL-92右外部联接。
- Outer join in which all rows from the table represented on the right will be included, even if they do not have matches in the related table. 在外部联接中将包括右边表中所有行,即使它们在相关的表中没有匹配项。
- You can include a WHERE clause with a full outer join to return only the rows where there is no matching data between the tables. 您可以在完全外部联接中包括WHERE子句,仅返回两表之间没有匹配数据的行。
- If you select the Left outer join type, you can click Swap Inputs to switch the inputs and convert the left outer join to a right outer join. 如果选择了“左外部联接”类型,那么可以单击“交换输入”来切换输入,将左外部联接转换为右外部联接。
- A left outer join is a join that returns each element of the first (left) data source, even if it has no correlated elements in the other data source. 左外部联接是这样一种联接,它返回第一个(左)数据源的每个元素,即使该元素在另一个数据源中没有关联元素。
- Null values returned from a base table are also difficult to distinguish from the null values returned from an outer join. 另外,从基表返回的空值与从外部联接返回的空值很难区分开。
- SQL Server provides the full outer join operator, FULL OUTER JOIN, which includes all rows from both tables, regardless of whether or not the other table has a matching value. SQL Server提供了完全外部联接运算符FULL OUTER JOIN,它将包括两个表中的所有行,不论另一个表中是否有匹配的值。
- The following illustration shows a conceptual view of two sets and the elements within those sets that are included in either an inner join or a left outer join. 下图显示了一个概念性视图,其中包含两个集合以及这两个集合中的那些包含在内部联接或左外部联接中的元素。
- When a self-reference appears within the FROM clause of the recursive subquery, the reference to the recursive table cannot appear on the null-supplying side of an outer join. 当自我引用出现在递归子查询的FROM子句中时,对递归表的引用不能出现在外连接的空值提供方。
- CREATE VIEW report.InfoOffice AS SELECT DISTINCT dbo.NTimeout.IP, dbo.NTimeout.msg, dbo.Res.LastUID, dbo.Res.Name, dbo.Res.OS FROM dbo.NTimeout LEFT OUTER JOIN dbo. 另外，我们需要建立一个VIEW从上面两张表中的到数据，以便Web Page中的ASPX可以快速的显示数据，而不需即时运算。
- The statement must not contain subqueries, outer joins, or self-joins. 语句不能包含子查询、外部联接或自联接。
- Placing a table on the right or left is significant for outer joins. 将表放在右边还是左边对于外连接非常重要。
- Why would I use an outer join? 为什么使用外部联接?
- How do I use an outer join? 如何使用外部联接?
- There are four basic types of joins: inner joins, outer joins, cross joins, and unequal joins. 有四种基本联接类型:内部联接、外部联接、交叉联接和不等联接。
- For more information about table ordering with left or right outer joins, see Using Outer Joins. 有关通过左向或右向外部联接排列的表的详细信息,请参阅使用外部联接。
- Most people's faces are asymmetrical. 多数人的脸并不对称。
