我们直接将两个表连接在一起，而不再使用子查询。
现在，把每个样式表连接到相应的Web服务操作，见表1。
Now connect each style sheet to its corresponding Web service operation, as shown in Table 1.
因此需要一个表连接图书和作者，而且这种连接必须是多对多的。
So you need a table to connect a book to an author, and you must allow those connections to be many-to-many.
若要将源表连接到二极管1，需要闭合通道1和21。
To connect the SourceMeter Instrument to diode 1, close Chs. 1 and 21.
细粒度的数据表意味着更多数据表连接，相应的查询也会更复杂。
Having fined-grained database tables means more table joins and accordingly more complex queries.
如果所有的维度表连接被该优化移除，则会读取全部事实表记录。
The entire fact table is read if all dimension table joins are removed by this optimization.
这样即把安培表连接到了管脚1，将电压源连接到了管脚2和3。
This will connect the ammeter to pin 1 and the voltage source to pins 2 and 3.
虽然没有人直说，但我想如果你要避免使用表连接，就会有很多去正规化工作。
No one said this explicily, but I presume there is a lot of de-normalization going on if you are avoiding joins.
编写使用这些比较高级的表连接的SQL查询将在后续文章中介绍。
Writing SQL queries that use these more advanced table joins will be addressed in future articles.
因为查询(通过使用隐式内连接)将两个表连接，您可以从两个表中选择列。
Table and use an AS clause to name these columns for the display with the ij tool. Because the query joins these two tables (by using an implicit inner join), you can select columns from both tables.
这种隐式关联避免了数据库表连接和额外的字段选择，降低了数据传输的大小。
This implicit association avoids database table joins and extra selections, and cuts down data transfer size.
正如上文所示，对具体类的查询只选择需要的数据，没有不必要的表连接和联合。
As shown above, queries on concrete classes only select the required data without unnecessary table joins or unions.
作为数据库开发人员，您通常将客户表与联系方式表连接，并将客户表视作主表。
As a database developer, you usually join the customer table to the contact table and treat the customer as the main table.
假设有一个涉及UNION的三表连接和来自查询的db 2 exfmt输出。
Here you have a three-table join involving a UNION, and from the db2exfmt output pertaining to the query, you have.
因为该方法在进行表连接之前，必须将所有的连接表分类，所以其成本通常极其高。
Because this method has to sort all joining tables before they join, the costs are usually pretty high.
用于该基准的数据库必须有10tb的原始数据，并且有高效的磁盘扫描和表连接算法。
The database used for this benchmark is defined with 10tb of raw data and requires highly efficient disk scanning and table joining algorithms.
然后，将该信息与CUSTOMER表连接，以提取客户姓名、地址和当前负债数。
This information is then joined with the CUSTOMER table in order to extract each customer's name, address, and current balance.
WHERE 子句执行的第二个主要功能是将多个表连接到单个表中，从而更易于查询。
The second major function performed by a WHERE clause is to join multiple tables together into a single table that can be queried more easily.
优化器然后使用复合索引将临时表连接到事实表，来快速定位在维度表中满足条件的行。
The optimizer will then join that temp table to the fact table using the compound index to quickly locate the rows that satisfy the criteria on the dimension tables.
这一节将重点介绍如何从单表中选择数据；本文中的最后一节将介绍表连接和如何从多个表中进行选择。
This section focuses on selecting data from a single table; the last section in this article covers table joins and selecting data from multiple tables.
在理想的情况下，当把电压表连接到一个没有电压的、阻抗比较低的电路时，电压表的读数应当为零。
Ideally, when a voltmeter is connected to a relatively low impedance circuit in which no voltages are present, it should read zero.
对于具有经常被请求的列的多个表，一种是复制其中的数据，一种是执行表连接，两者谁的成本更高呢？
Is the duplication of data in multiple tables of frequently requested columns, more or less expensive than performing the table joins?
ADMRDEPT字段的处理是相同的，该字段实际上是从employee表连接回其自身的一个链接。
Same with the ADMRDEPT field, which is actually a link from the EMPLOYEE table back to itself.
当一个数据驱动表连接到测试套件时，我们就可以将输入的各种组合的数据记录列入到测试脚本和动态变化的AUT行为中。
When a data-driven table is linked to the test suite, it is possible to specify several combinations of data records to input to the test scripts and to dynamically change the behavior of the AUT.
在缺乏表连接时，HBase通常使用去规范化(de - normalization)来将相关信息保存在一个表中。
In the absence of table joins, de-normalization is often used in HBase to keep related information in one table.
清单5要求用户将他或她的地点输入到一个表单中；然后它通过weather . bylocation表连接到Yahoo ！
Listing 5 asks the user to enter his or her location into a form; it then connects to the Yahoo!
清单7显示了如何指定抽象类的id属性查询抽象类Person，清单8显示了Hibernate自动生成的SQL查询，其中包括表连接？
Listing 7 shows how to query an abstract Person given its id property, while Listing 8 shows the SQL query automatically generated by Hibernate, including the table junctions.
如果想要使用不同的样式表执行附加转换，可以重用TransformerFactory，但必须创建不同的Transformer实例，以与新样式表连接。
If you want to perform additional transformations using a different stylesheet, you can reuse the TransformerFactory but must create a different Transformer instance, tied to the new stylesheet.
如果优化器首先连接两个表，那么连接结果可能十分庞大，并可能使用大量系统资源，如CPU和内存。
If the optimizer joins two tables first, the join results could be huge and may use a large amount of system resources such as CPU and memory.
他们委托外部系统管理其日程表，每天连接一次(或很少连接)来获取新预约。
They delegate an external system for managing their agenda, connecting once a day (or rarely) to get new appointments.
应用推荐