An association between input sources in a query that allows you to select rows that match plus those that do not match the join condition. You can select all of the rows from one input source and matching rows from the other input source with a Left Outer Join, Right Outer Join, or Full Outer Join. You can also select all of the rows from both input sources, regardless of matching, with a Full Outer Join.