In all three types of outer joins, the columns in the result row that are from the unmatched row are set ... Creating a Query View You can create an SQL view that contains the syntax of your query.