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

0 vote175 views4 answers
User defined function sql
SQL
2 votes164 views1 answer
SELECT INTO
SQL
2 votes157 views1 answer
Oracle cpu per session
SQL
2 votes153 views1 answer
Oracle sql drop table purge
SQL
1 vote172 views1 answer
Convert epoch to date in sql server
SQL
0 vote159 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote152 views2 answers
Postgresql create role
SQL
0 vote170 views1 answer
Login failed for login due to trigger execution
SQL
0 vote173 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote180 views1 answer
Compare if is null sql
SQL