difference between Union All and full outer join

[Barbie]

The output record set in union all contains same number of columns as in the input tables. But it concatenates all the records of both the input tables in the output. Both the input tables should have the same number of columns and same data types for those columns.

But the full outer join concatenates the columns in both the table. No need for the input tables to have same number of records.

[bvani]

Hi Barbie

That was a significant input thank you