Having Multiple Tables in FROM and Using JOIN

1 min read

INNER JOIN = JOIN

INNER JOIN is the default if you don’t specify the type when you use the word JOIN

INNER JOIN is ANSI syntax that you should use.

Why Use the New Syntax for SQL Joins?

  • Join conditions are separate from filtering conditions

  • Easier to join multiple tables

SQL

Related