Here is an example using the joined table strategy.
下面是一个使用联合表策略的示例。
You can copy from a single table or from joined tables.
可从单个表或联接表复制。
Inheritance: Annotations — Single table, joined table, and table per class.
继承:标注——单个表、联合表和按类表。
Specify that joined tables should include rows even when they do not match rows in the corresponding table.
指定即使某些行与相应表中的行不匹配,联接表也应包含这些行。
Joined table: (Optional) the child class is mapped to a table that has a foreign key relationship to the table to which the parent is mapped.
联合表:(可选)将子类映射到与父类映射到的表具有外键关系的表。
These two dimensions are joined through the sales fact table.
两个维度通过销售事实表连接起来。
This information is then joined with the CUSTOMER table in order to extract each customer's name, address, and current balance.
然后,将该信息与CUSTOMER表连接,以提取客户姓名、地址和当前负债数。
By now, my sisters have joined me at one end of the table where we pass the apple butter to each other to slather on the warm bread.
每到这时候,我就和姐妹们坐在桌子的一旁,相互传递苹果酱,在热烘烘的面包上抹上一层。
If a row has already been updated or deleted, then this row cannot be joined again with any source table row for another update or delete again.
如果一个行已被更新或者删除,那么不能针对该行再次更新与删除,再次与任何源表联接。
Data in this fact table would typically be joined with data in multiple dimension tables to obtain specific details about various products, regions, and so on.
这个事实表中的数据通常与多个维表中的数据联结,从而获取关于各个产品、地区等的特定信息。
Similarly, very often, the contents of an array needs to be turned into rows in a table, either to be stored or to be joined with other tables.
同样,很多时候,阵列的内容需要转变为表中的行,要么被存储或与其他表联合。
The attribute FIRST in the ACCESS guideline element specifies that the table CUSTACC must appear as the outermost table when the tables in the FROM clause are joined.
ACCESS准则元素中的属性FIRST指定在连接from子句中的表时,表CUSTACC必须作为最外层的表出现。
The account ID from this mapping operation can then be joined with the account ID included in the output of the Group By operation, creating a result set that will populate the target ACCT table.
然后,将该映射操作获得的账户ID与GroupBy操作的输出中包括的账户ID进行连接,创建一个结果集,该结果集将填充目标acct表。
Conceptually, the merge function joins source table rows with target table rows by applying the on clause filter. All the joined rows are updated or deleted on the target.
从概念上说,merge函数通过应用on子句过滤,将源表行与目标表行进行联接,所有联接的行都在目标中进行更新或者删除。
SKILL_OVERVIEW: The query subject containing all information from the SKILL_REPORT table joined with the job descriptions of the JOBS table.
SKILL_OVERVIEW:该查询主题包含 SKILL_REPORT表中所有与JOBS 表的职位描述相连接的信息。
The table is logically joined to itself, and the more selective non-leading index keys are applied as index bound filters to each unique combination of the leading key values.
首先在逻辑上将表与其自身连接,然后将更具有选择性的非起始索引键作为索引绑定过滤器,应用于起始键值的每个惟一的组合。
By making a view, rather than an explicit table, we avoid the main disadvantage of a vertical schema, namely that many queries require it to be joined with itself, which can be expensive.
通过定义视图而不是显式的表,可以避免垂直模式的主要缺点,即许多查询要求它与本身进行联结,而这种操作是很昂贵的。
The result is that the two dimensions will be joined through the sales fact table.
结果是两个维度将会在销售事实表中连接起来。
This second select statement is joined with the Common Table Expression (CTE) itself by linking parent to child data.
第二个SELECT语句通过将父数据链接至子数据与公共表表达式 (CTE) 联接。
John joined the long queue and eventually after a lengthy wait, reached the revenue table.
约翰加入到了那长长的队列里,等了很久以后,终于来到付款台前。
I had joined two tables from my database and for the life of me couldn't figure out how to get rid of the duplicate data that was coming from the table I joined.
我从数据库和加入了两个表的生活我无法弄清楚如何消除重复的数据来自表我加入。
In 1988, she joined the national table tennis team.
在1988年,她加入了国家乒乓球队。
In 1983, she joined the Henan table tennis team.
在1983年,她加入了河南乒乓球队。
Together, the pieces are joined to form the legs of a table.
各块木构件接合在一起组成了桌腿。
I joined in the conversation at table a little, ate a little, and when I had to throw up, I managed to make it to the toilet.
在饭桌上,我参与他们的谈话,吃少许的东西,如果非要呕吐不可,也能忍看到了洗手间才吐出来。
Nell joined us before long, and bringing some needle-work to the table.
不久耐儿也来到我们一起,把一些针钱活计放在桌上。
A table list containing the names of all tables being joined.
一个包含所有联结的资料表名称之资料表清单。
The shape of the icon in the middle of the join line indicates how the tables or table-structured objects are joined.
联结线中间的图示形状即表示资料表或表格化物件的联结方式。
The shape of the icon in the middle of the join line indicates how the tables or table-structured objects are joined.
联结线中间的图示形状即表示资料表或表格化物件的联结方式。
应用推荐