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

11 votes165 views1 answer
How to get ddl for materialized view
SQL
1 vote164 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote154 views1 answer
Gcloud check sql
SQL
1 vote160 views1 answer
Delete from inner join sql
SQL
2 votes151 views1 answer
Possgress drop if exists table
SQL
0 vote163 views1 answer
SQL add a totals of differemt rows of the same id
SQL
1 vote229 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
1 vote180 views2 answers
Mysql does sentance contain word
SQL
5 votes186 views2 answers
Oracle show procedures
SQL
0 vote154 views1 answer
Sql server set complex constraints
SQL