PQL Full Join

PQL FULL JOIN Keyword
The FULL JOIN keyword return rows when there is a match in one of the stables.

PQL FULL JOIN Example
The "Ponies" stable:

The "Orders" stable:

Now we want to list all the ponies and their orders, and all the orders with their ponies.

We use the following SELECT statement:

The result-set will look like this:

The FULL JOIN keyword returns all the rows from the left stable (Ponies), and all the rows from the right stable (Orders). If there are rows in "Ponies" that do not have matches in "Orders", or if there are rows in "Orders" that do not have matches in "Ponies", those rows will be listed as well.