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 vote382 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
2 votes321 views2 answers
Postgres select duplicate columns
SQL
0 vote338 views1 answer
Like sql for second letter of the family name
SQL
0 vote338 views1 answer
Enable sql server full text indexing
SQL
0 vote333 views1 answer
Sql query to find duplicate email address
SQL
0 vote317 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote338 views1 answer
How to check which table has data in mysql
SQL
1 vote342 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote311 views1 answer
Sql select most frequent value in group
SQL
1 vote350 views1 answer
Mysql connect bash
SQL