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

5 votes99 views1 answer
Mysql add user with all privileges
SQL
0 vote103 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote115 views1 answer
Exectuer myssql .sql
SQL
0 vote137 views1 answer
Pl sql search in all packages
SQL
0 vote108 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote108 views2 answers
Zsh: command not found: mysq
SQL
0 vote107 views1 answer
Postgres float to int
SQL
0 vote104 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote120 views1 answer
Sql combine results from two tables
SQL
1 vote115 views1 answer
Backup mysql data only
SQL