PDQ.com mobilePDQ.com desktop
Support

SQL JOINS

Stephanie WarnerStephanie Warner
·

The JOIN clause is used to join two or more tables together based on a matching column between the tables. The result set combines records from each table based on the matching column. The column(s) used to join tables together are typically referred to as ‘Primary’ or ‘Foreign’ keys.

There are four major types of joins used in SQL syntax:

  1. INNER JOIN

  2. LEFT JOIN

  3. RIGHT JOIN

  4. FULL (OUTER) JOIN

‘INNER’ and ‘OUTER’ keywords in the JOIN clauses are optional and not required in the syntax.

(INNER) JOIN

LEFT JOIN

RIGHT JOIN

FULL (OUTER) JOIN


This blog post is part of our SQL series:

SQL Set Operators

SQL UNION vs UNION ALL

SQL INNER JOIN

SQL LEFT JOIN

SQL Right Join

SQL Full Outer Join

Ready to get started?

Take our 14-day Free Trial.
This round is on us!

Don't miss the next post!

Using PowerShell to Install Printers

When installing printers, we will need to do the four things; Add Driver to the Store, Install the Driver, Create Printer Port, and Install the Printer