Search form

SQL

Stupid SQL Tricks

Joins

This intends to provide a brief summary of JOIN operations. I'm attempting to follow standard SQL here where possible, thus avoiding, say, Oracle terminology like ANTIJOIN and SEMIJOIN. All SQL databases that I've encountered perform LEFT/RIGHT/INNER JOIN as expected, but others will show some variation. When in doubt, refer to your documentation.

The generic JOIN procedure uses the following syntax:

Subscribe to RSS - SQL