WEBFOCUS TABLE JOIN操作

来源:互联网 发布:4s上的数据如何备份 编辑:程序博客网 时间:2024/06/18 10:57
Example: A Unique Equijoin Structure

The following example illustrates a unique joined structure.
Two FOCUS data sources are joined together: an EMPDATA data source and a
SALHIST data source. Both data sources are organized by PIN,
and they are joined on a PIN field in the root segments of both files.
Each PIN has one segment instance in the EMPDATA data source,
and one instance in the SALHIST data source. To join these two data sources,
issue this JOIN command:





 

JOIN PIN IN EMPDATA TO PIN IN SALHIST

EMPDATA 表的PIN  与SALHIST表的PIN  做连接。