Keep both sides with FULL OUTER JOIN

A reconciliation report may need every case: a valid match, a customer without an order, and an order without a customer. Preserve both sides and identify what is missing.

Keep matched rows and unmatched rows from either side. Values from the missing side become NULL.

Keep both sides with FULL OUTER JOIN: Keep matched rows and unmatched rows from either side. Values from the missing side become NULL.