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 vote198 views1 answer
Update and replace mysql
SQL
1 vote191 views1 answer
Foreign key constraint in ms sql
SQL
0 vote335 views1 answer
Sql change a colum to unique
SQL
0 vote208 views1 answer
Gcloud sql instance list
SQL
0 vote216 views1 answer
Sql developer sql worksheet not showing
SQL
1 vote211 views1 answer
Mysql select from outside
SQL
1 vote196 views1 answer
Oracle db create new schema
SQL
0 vote200 views1 answer
How to change the field size of an existing column
SQL
4 votes208 views2 answers
Bulk kill mysql processlist
SQL
6 votes217 views2 answers
How to copy data in sql
SQL