In SQL terms, this merge calls for an outer join, which matches each row in the work items data set to the single row in the states data set with a matching state ID.

在sql术语中，该合并会调用一个外层联系，它会将工作项数据集合中的每一行，与状态数据集合中的单个行使用匹配状态ID来匹配起来。

youdao

Add a computed column to the work items data set named "STATE ID" that concatenates the project area name with the STATE_NAME column (see Listing 6). The value for this column might look like this.

向名为“STATE ID”的工作项数据集添加一个计算的列，它将下面区域名字与state_name列联系起来(参见代码清单6)。

youdao

At Hyatt hotels generally, passports, credit CARDS, state ID CARDS, computers, wedding rings and other jewelry, MP3 players and cash are most often left behind, says Hyatt spokeswoman Lori Alexander.

凯悦发言人罗莉。亚历山大说，落在凯悦酒店常见失物有：护照、信用卡、身份证、计算机、婚戒和其他首饰、MP3和现金。

youdao

And since state ID such as a driver's license or birth certificate often vary by state or county, he adds, it's almost impossible for service employees to verify the authenticity.

CNN: Expert: Hijackers likely skilled with fake IDs

But her state has its own income tax, so she had to register for a separate ID number to report and pay employee state tax withholding, and then had to fill out yet another registration for another ID number to file another regular report to pay state unemployment taxes.

FORBES: When Julia Tried to Start a Business

In October, the South Carolina Department of Elections reported that some 240, 000 state voters lacked ID cards.

WSJ: Review & Outlook: Holder's Racial Politics