The FULL JOIN keyword return rows when there is a match in one of the tables.
The "Persons" table:
The "Purchases" table:
Now we want to list all the persons and their Purchases, and all the Purchases with their
We use the following SELECT statement:
The result-set will look like this:
The FULL JOIN keyword returns all the rows from the left table (Persons), and all the rows from
the right table (Purchases). If there are rows in "Persons" that do not have matches
in "Purchases", or if there are rows in "Purchases" that do not have matches
in "Persons", those rows will be listed as well.
Your Query was successfully sent!