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 vote283 views1 answer
Sp in sql server
SQL
1 vote274 views2 answers
Restart identity cascade
SQL
5 votes234 views1 answer
Copy table from one database to another mysql
SQL
0 vote284 views1 answer
Initcap in mysql
SQL
0 vote267 views1 answer
Many rows to 1 string mysql
SQL
7 votes289 views1 answer
Mysql iif
SQL
0 vote248 views1 answer
Postgres create database if not exists
SQL
0 vote276 views1 answer
Sql alter table order by
SQL
16 votes275 views2 answers
Oracle ddl
SQL
0 vote268 views1 answer
2020 new year
SQL