Define a join relationship for a view

  1. 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.
  2. Select a join type for the new view. The default join type is an inner join.
  3. To change the criteria of the relationship, click Join Condition.
  4. Click to select a column, operator, or function.
  5. Double-click to add the selection to the clause.
  6. The clause is constructed in the Clause box below. Column functions are not allowed in a join condition.
  7. Click OK when you are done selecting a join type.

Notes for the work area:

Once you have established your join relationship, you may now:

If you want to do none of these things, click OK to create your new view.