Use where instead of join

# using WHERE ANSI-89 syntax
SELECT *
  FROM TABLE_A a,
       TABLE_B b
 WHERE a.id = b.id

# using JOIN ANSI-92 syntax
 SELECT *
  FROM TABLE_A a
  JOIN TABLE_B b ON b.id = a.id

Source: stackoverflow.com

Similar codes

3 votes331 views2 answers
How to modify rows in SQL Server
SQL
0 vote345 views1 answer
Laravel migration sql dump
SQL
2 votes299 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
3 votes309 views1 answer
Mysql UPDate with enner join
SQL
0 vote321 views1 answer
Sql not exists
SQL
0 vote368 views1 answer
MySQL - Enabling the Event Scheduler
SQL
2 votes359 views2 answers
Calculate percentage in sql
SQL
6 votes380 views6 answers
Rename column postgres
SQL
0 vote335 views1 answer
Select nth row in mysql
SQL
13 votes321 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL