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

Additional information about the differences of these JOINs are located in corresponding blog articles.

Ready to get started?

This round is on us!
Start a Trial

Don't miss the next post!

Introducing PDQ Deploy & PDQ Inventory Beta version 19.0.7.0

Introducing the PowerShell Scanner for PDQ Inventory in its first public beta version 19.0.7.0. Discover the power of scanning for pretty much anything.