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

1 vote211 views2 answers
Intersect sql
SQL
0 vote196 views1 answer
Sintaxis SELECT sql
SQL
0 vote199 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
14 votes193 views2 answers
Oracle export trigger ddl
SQL
0 vote183 views1 answer
Disableforiegn key check
SQL
-3 votes264 views8 answers
Sql to c# linq converter online
SQL
0 vote219 views1 answer
How to join result table in mysql
SQL
12 votes205 views2 answers
Insert multiple rows from another table sql
SQL
0 vote181 views1 answer
Narural join
SQL
0 vote191 views1 answer
MySql Modify Increment
SQL