Join Options

Once your links have been established, you may double click on the join icon (button with = sign) on the green linking lines to modify your links.  The following window will appear.

  

• Outer Join:
  Check this box to indicate that you want an "outer join" performed.  There are two kinds of join formats: SQL92 and Use"(+)".  With conventional joins, records that do not satisfy the join condition are eliminated from the result. Outer join preserves these records in the result and replaces the missing value with nulls.  We call the join "left (right) outer join" if the records in the left (right) side table are preserved.  For example, consider the following two tables:
  
  

The conventional join of Customer.C# = Order.C# will produce the following result:

The left outer join of Customer.C# = Order.C# will produce the following result:

The right outer join of Customer.C# = Order.C# will produce the following result:

• Drop Down Menu:
  
  =    Will display values that are equal to each other
  >    Will display values that are greater on the left side
  <    Will display values that are greater on the right side
  >=  Will display values that are greater than or equal to the left side
  <=  Will display values that are greater than or equal to the right side
  <>  Will display values that are not equal to each other