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 vote353 views2 answers
Mysql error 1215
SQL
8 votes388 views3 answers
Postgres connection string
SQL
0 vote360 views1 answer
How to select even id in sql
SQL
0 vote362 views1 answer
How to alter length character varying postgres
SQL
0 vote335 views1 answer
Oracle index hint multiple tables example
SQL
0 vote342 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote375 views1 answer
Get a list of tables and the primary key
SQL
0 vote370 views1 answer
Multiple left join mysql
SQL
0 vote364 views1 answer
Get enginge db mysql
SQL
12 votes343 views1 answer
How to change the value of a table in sql
SQL