单词 | outer join | ||||||||||||||||
释义 | outer join
更多释义 收起释义 例句释义: 外连接,外部连接,外联接 1. 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子句,仅返回两表之间没有匹配数据的行。 www.bing.com 2. The fact that this is also called an INNER JOIN might also indicate that an alternative called OUTER JOIN exists. 这也被称为INNERJOIN,这一事实也表明有另一种称作OUTERJOIN的类型存在。 www.ibm.com 3. The tables or views in the FROM clause can be specified in any order with an inner join or full outer join. FROM子句中的表或视图可通过内部联接或完整外部联接按任意顺序指定。 technet.microsoft.com 4. Specifies the provider supports references to multiple tables in the WHERE clause, as long as they are not outer join references. 指定提供程序支持在WHERE子句中引用多个表,条件是这些引用不是外部联接引用。 technet.microsoft.com 5. The merge statement first does a join (outer join or inner join, depending on the merge statement) between source and target table rows. merge语句首先进行(外部联接或者内部联接,取决于merge语句)源与目标表行之间的联接。 www.ibm.com 6. To retain the nonmatching information by including nonmatching rows in the results of a join, use a full outer join. 若要通过在联接的结果中包括不匹配的行来保留不匹配信息,请使用完全外部联接。 msdn2.microsoft.com 7. A type of outer join in which all rows from the left-most table in the JOIN clause are included. 一种外部联接,其中包括JOIN子句中最左侧表中的所有行。 technet.microsoft.com 8. Null values returned from a base table are also difficult to distinguish from the null values returned from an outer join. 另外,从基表返回的空值与从外部联接返回的空值很难区分开。 msdn2.microsoft.com 9. However, the order of tables or views specified when using either a left or right outer join is important. 但是,用左向或右向外部联接时,指定表或视图的顺序很重要。 msdn2.microsoft.com 10. A right outer join is the reverse of a left outer join. 右向外部联接是左向外部联接的反向联接。 technet.microsoft.com 1. Note that the join being performed is an outer join. 注意,所执行的联接是个外部联接。 www.ibm.com 2. This query performs an outer join to compare the sales information for 10 particular stores for January and November. 这个查询会执行一个外连接操作,以便比较从1月份至11月份的10个特殊商店的销售信息。 www.ibm.com 3. An outer join can be further restricted by using a predicate. 使用谓词可以进一步限定外部联接。 msdn2.microsoft.com 4. In this regard, the query is similar to a left outer join in SQL. 从这种意义上说,查询与SQL中的左外连接相似。 www.ibm.com 5. All rows from both tables are returned in a full outer join. 在完全外部联接中,将返回两个表的所有行。 msdn2.microsoft.com 6. In this case, the Transact-SQL outer join is converted to an ANSI outer join. 这种情况下,Transact-SQL外连接转换为ANSI外连接。 www.ianywhere.com 7. A type of outer join in which all rows in the table on the right in the JOIN clause are included. 包含JOIN子句中右侧表所有行的一种外部联接。 technet.microsoft.com 8. For more information about outer join syntax, see the topic LEFT JOIN, RIGHT JOIN Operations. 有关外部联接语法的详细信息,请参阅主题LEFTJOIN和RIGHTJOIN操作。 office.microsoft.com 9. Left Outer Join: In Left Outer Join, all the rows in the first-named table, i. e. 左外联接:在左外联接中,第一张表中的所有行将被包含。 www.bugsboard.net 10. Right Outer Join: In Right Outer Join, all the rows in the second-named table, i. e. 右外联接:在右外联接中,第二张表中的所有行将被包含。 www.bugsboard.net 1. 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右外部联接。 www.bing.com 2. These operators are not supported; the OUTER JOIN keyword should be used. 不支持使用这两个运算符;应使用OUTERJOIN关键字。 msdn2.microsoft.com 3. A full outer join returns all rows in both the left and right tables. 完整外部联接将返回左表和右表中的所有行。 technet.microsoft.com 4. To include all products, regardless of whether a review has been written for one, use an SQL-92 left outer join. 若要包括所有产品,不论是否已编写审核,请使用SQL-92左外部联接。 msdn2.microsoft.com 5. Join dialog box, you can specify a join based on a different operator, and you can specify an outer join. “联接”对话框中设置选项,可以基于不同运算符指定联接,并且可以指定外部联接。 technet.microsoft.com 6. Using eager inner or outer join fetching will repeat pojoA many times in the result set. 使用立即的内连接或外连接抓取会在结果集中将pojoA重复很多次。 www.infoq.com 7. You join two tables by using an inner join or an outer join. 可以通过使用内连接或外连接来连接两个表。 www.ibm.com 8. There is also a full outer join between these two sub queries based on a column called sc. 在基于名为sc的列上还有两个子查询的完全外连接。 www.ibm.com 9. left join or left outer join is a join that presents values for matched values and those that present only in the left table 左连接或左外连接表示匹配值和只出现在左表中的的值。 www.ichacha.net 10. The following outer join escape sequences are supported by the JDBC driver JDBC驱动程序支持下列外部联接转义序列 msdn2.microsoft.com 1. Here is the Transact-SQL query and results of the right outer join 下面是Transact-SQL查询和右外部联接的结果 msdn2.microsoft.com 2. Outer Join Query for Several Tables with SQL SQL多表外连接查询 www.ilib.cn 3. Change an inner join to an outer join 将内部联接更改为外部联接 office.microsoft.com 4. RIGHT OUTER JOIN RIGHT OUTER JOIN 右外连接 wenku.baidu.com 5. For example, the following SELECT statement does a left outer join on these two tables 例如,下面的SELECT语句对这两个表进行左向外部联接 msdn2.microsoft.com |
||||||||||||||||
随便看 |
|
英汉双解词典包含2704715条英汉词条,基本涵盖了全部常用单词的翻译及用法,是英语学习的有利工具。