Define a join relationship for a view
- To define join relationships for the new view, in the work area, drag a column name from one table to a column name in
another table. A line connecting the two columns will appear, and the Join Properties dialog opens.
- Select a join type for the new view. The default join type is an inner join.
- To change the criteria of the relationship, click Join Condition.
- Click to select a column, operator, or function.
- Double-click to add the selection to the clause.
- The clause is constructed in the Clause box below. Column functions are not allowed in a join condition.
- Click OK when you are done selecting a join type.
Notes for the work area:
- There can be only one join line highlighted at a time.
- To bring up a context menu where you can view properties of the join or delete the join, right-click the join line.
- To remove a join, right-click the join line representing the join condition and click Delete. You can also click the join
line to highlight it, and then press the Delete key.
Once you have established your join relationship, you may now:
- Establish some selection criteria
- View or edit the SQL used to create the view
- Create a formula from two or more of the columns
If you want to do none of these things, click OK to create your new view.