You have a Fabric tenant with a lakehouse. You intend to use a visual query to merge two tables. You need to guarantee that the query returns all rows from both tables.

Which join type should you use?