In SQL terms, this merge calls for an outer join, which matches each row in the work items dataset to the single row in the states dataset with a matching state ID.
You will use this text field in place of the usual data fields that show information from the dataset, such as the summary and ID of work items.
您将会看到该文本区域位于从数据集显示信息的数据区域，例如工作项的总结与ID。
3
Add a computed column to the work items dataset 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.