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

7 votes152 views5 answers
Max 3 salary in sql
SQL
1 vote173 views2 answers
Login to mysql
SQL
4 votes170 views1 answer
Mysql query first character
SQL
0 vote147 views1 answer
Get the Db column names from a SqlDataReader
SQL
10 votes143 views3 answers
How to fetch first 5 characters in sql
SQL
1 vote218 views1 answer
Mysql breakline on string
SQL
1 vote136 views1 answer
Setval pgsql
SQL
0 vote141 views1 answer
Min salary in sql
SQL
1 vote129 views1 answer
Influxdb export to csv
SQL
1 vote152 views1 answer
Mysql show database size in mb
SQL