The "Join Properties" dialog allows users to create table joins within the Query Builder. A join is a means for combining fields from two tables by using values common to each.
Join type options include Inner, Left Outer, Right Outer, and Full Outer.
See also: