SQL - ilya-khadykin/notes-outdated GitHub Wiki

This page contains common SQL commands used in day-to-day work

INNER JOIN

Syntax:

SELECT *
FROM left_table
INNER JOIN right_table
ON left_table.id = right_table.id;

SELECT *
FROM left_table
  INNER JOIN right_table
    USING(id)