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 vote201 views1 answer
Mysql select if empty result
SQL
0 vote249 views1 answer
Sql database size
SQL
1 vote198 views1 answer
Postgres get month name from date
SQL
2 votes194 views1 answer
Oracle drop sequence if exists
SQL
1 vote169 views1 answer
Sql insert for each distinct value
SQL
1 vote152 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
6 votes191 views2 answers
Sql display max value
SQL
0 vote214 views1 answer
Sqlite unique multiple columns
SQL
3 votes176 views2 answers
Brew start mysql
SQL
23 votes198 views4 answers
Uninstall postgresql ubuntu
SQL