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 vote164 views1 answer
Extract sql from query object sqlalchemy
SQL
1 vote173 views1 answer
OSError: mysql_config not found
SQL
4 votes146 views1 answer
What are the data types in sql
SQL
0 vote162 views2 answers
How to combine two sql queries in one result
SQL
0 vote150 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote202 views1 answer
Add week ending date sql server
SQL
0 vote158 views1 answer
Empty table sqlite
SQL
1 vote160 views2 answers
Insert sqlite
SQL
11 votes169 views3 answers
Sql line numbers
SQL
2 votes229 views1 answer
Postgresql group by month and year
SQL