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 vote351 views1 answer
Postgresql default value boolean
SQL
0 vote389 views1 answer
Run sql script file and changes db name in this file using c#
SQL
3 votes376 views2 answers
MySQL query to get column names
SQL
28 votes327 views4 answers
Mysql delete database
SQL
0 vote456 views1 answer
Delet all record statment sql
SQL
0 vote355 views1 answer
Django mssql backend
SQL
1 vote344 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote349 views1 answer
Sql delete where x or y or z
SQL
0 vote350 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote382 views1 answer
Min mysql
SQL