Join Type

This field specifies how secondary tables are to be joined to other IDO tables.

Select Inner join only if the columns referenced in the join are not nullable and the join is on a foreign key. Otherwise, select Left Outer join.