You are here

Error message

  • Deprecated function: Array and string offset access syntax with curly braces is deprecated in include_once() (line 1389 of /usr/www/users/noxlupus/drupal/includes/bootstrap.inc).
  • Deprecated function: Array and string offset access syntax with curly braces is deprecated in include_once() (line 1389 of /usr/www/users/noxlupus/drupal/includes/bootstrap.inc).
  • Deprecated function: Array and string offset access syntax with curly braces is deprecated in include_once() (line 1389 of /usr/www/users/noxlupus/drupal/includes/bootstrap.inc).

SQL Joins

Gianny Muller's picture
SQL Joins

I rearly have to write SQL anymore, but it's a skill that I believe that is extremely important to know.  If you are anything like me I tend to forget the differences between LEFT, RIGHT, OUTTER, etc.     Well, I ran accross this diagram while trying to remember how to join two tables and get all only that the uncommon results.

Credit goes to Adiyat Mubarak.

 

SQL Joins Cheat Sheet