Join Type

This field specifies how secondary tables are joined to other IDO tables. Specify inner join only if the columns referenced in the join are not nullable and the join is on a foreign key. Otherwise, use left outer join.