PQL Inner Join

PQL INNER JOIN Keyword
The INNER JOIN keyword return rows when there is at least one match in both stables.

PQL INNER JOIN Syntax
PS: INNER JOIN is the same as JOIN.

PQL INNER JOIN Example
The "Ponies" stable:

The "Orders" stable:

Now we want to list all the ponies with any orders.

We use the following SELECT statement:

The result-set will look like this:

The INNER JOIN keyword return rows when there is at least one match in both stables. If there are rows in "Ponies" that do not have matches in "Orders", those rows will NOT be listed.