Page Comparison

Using conditional joins, you can establish joins based on conditions other than equality between fields. In addition, the host and cross-referenced join fields do not have to contain matching formats, and the cross-referenced field does not have to be indexed. 

The conditional join is supported for FOCUS and all relational data adapters. Because each data source differs in its ability to handle complex conditional criteria, the optimization of the WHERE syntax differs depending on the specific data sources involved in the join and the complexity of the conditional criteria.

...

1. Either open an existing report or create a new report. 

2. If creating a new report, opening the first table of data.  
   

   Note
   The first table you select cannot be changed in a report; therefore be sure to confirm the table selected is accurate before opening.

   
   

3. Once the correct table is selected, click Open.  
4. From within the report, click the Data tab, then click Join, from the ribbon.
   
5. From the Join dialog box, click Add New. 
6. From the Open dialog box, select a second table.  
7. Click Open.  
8. The Join dialog box displays two tables at this point.  
9. Identify the common field of data in both tables.  
10. Left-click the field name in the first table and hold to ensure the data remains selected.  
    
11. Drag the selected data to the second table, releasing the left-click over the matching field name of data in the second table.  
    
12. Notice the arrow between the two tables, indicating the join is successful.  
    
13. Left-click in the middle of the arrow, to change the arrows color to red.  
14. Right-click in the middle of the red arrow. 
15. Click to select Edit from the list of available options that display, to modify the join.  
    

16. From the Edit Join dialog box, confirm the selections from the Instances and Type dropdown menus are accurate for your Join. 
    Image Modified

    Note

    NOTE - The Instances dropdown options – Single - will go for a single match.  If you there are multiple instances of the specific data in the tables, select multiple to instruct the join to search the second table of multiple instances of that value.  The Type dropdown options Default - gets all rows in all tables.  Inner gets all rows that exists in both tables.  Left Outer - goes through first data, produces complete list of data, then goes through second table to see if there is matching data.   For example, select Inner, from

    the Type dropdown

    the Type dropdown to get.....  if you select Outer Left from

    the Type dropdown

    the Type dropdown to get.....  select Default from the Type dropdown to get..... ← Jean to add specific examples

    
    

17. Click OK  to confirm your selectionOK.  
18. To confirm your two tables have been joined, navigate to the left data pane from the main report view. 
19. Click the arrow to expand the list of field names in the first table. 
    Image Added
20. Scroll down to the bottom of the left data pane to locate the second table. 
21. Click the arrow to expand the list of field names in the second table. 
    Image Added
22. To build the report, select appropriate fields from either table, then drag then drag them to the appropriate quadrant to display in your report.   
    
    
    
23. NOTE- To add additional tables to this join, repeat the steps above at any point.   

Related Articles

...