what is the difference between union all and full outer join?
Difference between Union All and Full outer join. The output record set in UNION ALL contains same number of columns as in the input tables. ... But the full outer join concatenates the columns in both the table. No need for the input tables to have same number of records.