Can you perform a JOIN without using an explicit JOIN keyword (i.e., using WHERE)? Explain.

Difficulty: 4/10

implicit joins, WHERE clause, SQL readability

Joining Tables Using WHERE Instead of JOIN

Yes, you can perform a JOIN in MySQL without using the JOIN keyword. This older syntax uses multiple tables in the FROM clause and specifies the join condition in the WHERE clause. It works, but it behaves differently for INNER and OUTER joins.

1. INNER JOIN Using WHERE

1
• Before ANSI JOIN syntax became standard, INNER JOINs were commonly written using WHERE.
2
• This behaves exactly like an INNER JOIN.
3
4
Example:

Can you perform a JOIN without using an explicit JOIN keyword (i.e., using WHERE)? Explain.

Difficulty: 4/10

implicit joins, WHERE clause, SQL readability

Joining Tables Using WHERE Instead of JOIN

1. INNER JOIN Using WHERE

1
• Before ANSI JOIN syntax became standard, INNER JOINs were commonly written using WHERE.
2
• This behaves exactly like an INNER JOIN.
3
4
Example:

Can you perform a JOIN without using an explicit JOIN keyword (i.e., using WHERE)? Explain.

Joining Tables Using WHERE Instead of JOIN

Can you perform a JOIN without using an explicit JOIN keyword (i.e., using WHERE)? Explain.

Joining Tables Using WHERE Instead of JOIN

Scenario Questions

Follow-up Questions