In this topic you will learn how to create a Standard (Any) Join.
Navigation: Click the Main Menu link > Reporting Tools > Query > Query Manager
Query Manager allows the creation of a join between two records (any record join) by selecting your initial base record, then returning to the Record page to select the second record.
Unlike Hierarchy Joins, Standard (Any) joins are not predefined in the system. You must manually join the tables/records when using a Standard (any) Join.
NOTE: When creating a Standard Join, the records you wish to join must have a common key field for joining. Query will attempt to automatically join the records based on the keys in each record.
Click the Search button.
In this example, you will join the PO_HDR record and the PO_LINE_DISTRIB record to retrieve Purchase orders between a date range for a specific business unit, and find the merchandise amount and the department ID number.
Click the Records tab to select the other record to join to the PO_HDR record.
In the Join Type section, the system defaults to the "Join to filter and get additional fields (Standard Join)". This should remain as defaulted.
Click the Add Criteria button.
Click the Run tab to preview your query results.
Click the Save As link to save your query.
Click the OK button.
The results for the Standard Join query displays.
Enter the following date range: 01/01/15 - 01/31/15
NOTE: When creating queries it is optimal to select a smaller data sample for testing, such as 01/01/15-01/31/15. This will result in a quicker run time, and make it easier to test and troubleshoot your query.
Click the Fields tab.
Enter the name of your query and if desired, enter a longer description of the query in the Query Definition box.
This completes Standard (Any) Joins.