A data engineer aims to horizontally combine two tables in a query, using a shared column as the key. The desired outcome includes rows with key values present in both tables, plus any non-matching rows from either table. Which SQL command achieves this?