Joining on more than one key
You can specify more than one join condition when joining two data sets. For example, you can join a customers data set with a sales offices data set, shown in Figure 13-15, to find the names of customers and sales managers that are located in the same city and state.
Figure 13-15  
You would create the following join conditions:
The first condition, shown in Figure 13-16, compares the State values in the Customer and SalesOffices data sets and looks for a match.
Figure 13-16  
The second condition, shown in Figure 13-17, compares the City values in both data sets and looks for a match.
Figure 13-17  
The joined data set returns the results shown in Figure 13-18, if the join type is fullOuter.
Figure 13-18  

Additional Links:

Copyright Actuate Corporation 2012