outer join with row archival

Additional Information