您要查找的是不是：
- A self-join can be an inner join or an outer join. 自聯(lián)接可以是內部聯(lián)接,也可以是外部聯(lián)接。
- A type of outer join in which all rows from the left-most table in the JOIN clause are included. 一種外部聯(lián)接,其中包括JOIN子句中最左側表中的所有行。
- SELECT TOP 1 * FROM T1 LEFT OUTER JOIN T2 ON T1.Id = T2.ParentId ORDER BY T1.Id ASC . 版權申明：本站文章均來(lái)自網(wǎng)絡(luò )，如有侵權，請聯(lián)系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. 若要在結果中包括所有銷(xiāo)售人員,不論是否為他們分配了區域,請使用SQL-92右外部聯(lián)接。
- 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. 在外部聯(lián)接中將包括右邊表中所有行,即使它們在相關(guān)的表中沒(méi)有匹配項。
- 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. 您可以在完全外部聯(lián)接中包括WHERE子句,僅返回兩表之間沒(méi)有匹配數據的行。
- 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. 如果選擇了“左外部聯(lián)接”類(lèi)型,那么可以單擊“交換輸入”來(lái)切換輸入,將左外部聯(lián)接轉換為右外部聯(lián)接。
- 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. 左外部聯(lián)接是這樣一種聯(lián)接,它返回第一個(gè)(左)數據源的每個(gè)元素,即使該元素在另一個(gè)數據源中沒(méi)有關(guān)聯(lián)元素。
- Null values returned from a base table are also difficult to distinguish from the null values returned from an outer join. 另外,從基表返回的空值與從外部聯(lián)接返回的空值很難區分開(kāi)。
- 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提供了完全外部聯(lián)接運算符FULL OUTER JOIN,它將包括兩個(gè)表中的所有行,不論另一個(gè)表中是否有匹配的值。
- 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. 下圖顯示了一個(gè)概念性視圖,其中包含兩個(gè)集合以及這兩個(gè)集合中的那些包含在內部聯(lián)接或左外部聯(lián)接中的元素。
- 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. 當自我引用出現在遞歸子查詢(xún)的FROM子句中時(shí),對遞歸表的引用不能出現在外連接的空值提供方。
- 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. 另外，我們需要建立一個(gè)VIEW從上面兩張表中的到數據，以便Web Page中的ASPX可以快速的顯示數據，而不需即時(shí)運算。
- The statement must not contain subqueries, outer joins, or self-joins. 語(yǔ)句不能包含子查詢(xún)、外部聯(lián)接或自聯(lián)接。
- Placing a table on the right or left is significant for outer joins. 將表放在右邊還是左邊對于外連接非常重要。
- Why would I use an outer join? 為什么使用外部聯(lián)接?
- How do I use an outer join? 如何使用外部聯(lián)接?
- There are four basic types of joins: inner joins, outer joins, cross joins, and unequal joins. 有四種基本聯(lián)接類(lèi)型:內部聯(lián)接、外部聯(lián)接、交叉聯(lián)接和不等聯(lián)接。
- For more information about table ordering with left or right outer joins, see Using Outer Joins. 有關(guān)通過(guò)左向或右向外部聯(lián)接排列的表的詳細信息,請參閱使用外部聯(lián)接。
- Most people's faces are asymmetrical. 多數人的臉并不對稱(chēng)。
