This page allows you to specify the join conditions for merging two tables in a view.
Note: At least two tables should be specified for the view, to specify the joins.
Select the “Specify Joins” link in the “Define View” page.
The system displays the following:
|
View Display Name |
The name of the view, as it appears in the “Inquiries” activity. |
|
View Type |
The type of the view, which could be “Adhoc”, “Audit” or “Report”. |
|
View Access |
The access type of the view, which could be “Public” or “Private”. |
Enter the following fields in the “Join Conditions” multiline:
|
Source Table Name |
The name of the table that must be merged with the target table in the view (Alphanumeric, 255). |
|
Source Column Name |
The name of the column in the source table, matching with the column in the target table (Alphanumeric, 255). |
|
Join Type |
Use the drop-down list box to specify the join type. The system lists the following options: “Inner Join”, “Left Outer Join” and “Right Outer Join”. |
|
Target Table Name |
The name of the table that must be merged with the table specified as the source table (Alphanumeric, 255). |
|
Target Column Name |
The name of the column available in the target table, matching with the column in the source table (Alphanumeric, 255). |
Click the “Save” pushbutton to store the details.
