In #SQL the FULL OUTER JOIN combines the results of both left and right outer #joins and returns all (matched or unmatched) rows from the tables on both sides of the join #clause.
Note: FULL OUTER JOIN can potentially return very large result-sets!
Website: https://www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis