What result does an Outer Join produce in QlikView?

An Outer Join in QlikView is designed to include all rows from one or both of the tables involved in the join, even if there are no matches between the tables. This means that every row from the primary table will be preserved, and rows from the secondary table will contribute where there are matches. However, for those entries in the primary table that do not have corresponding matches in the secondary table, the resulting record will still appear in the output, but with null values for any of the fields that originate from the secondary table where there was no match.

This characteristic allows for a more comprehensive view of the data, as it does not discard rows simply because there is no corresponding value in another dataset. For instance, if you're working with customer and order tables, an Outer Join will show all customers, including those who have not placed any orders, with nulls in the order-related fields. This retention of non-matching rows is why Outer Joins are particularly useful when trying to maintain complete datasets while analyzing relationships between tables.