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 vote232 views1 answer
Check if mysql is installed
SQL
2 votes238 views3 answers
Current setting postgres timezone
SQL
1 vote228 views1 answer
Select count distinct multiple columns sql server
SQL
1 vote222 views1 answer
Tsql random number
SQL
1 vote222 views1 answer
Sql Split string function
SQL
0 vote281 views1 answer
TSQL Find csv file in folder
SQL
0 vote189 views1 answer
Flask_sqlalchemy install
SQL
0 vote222 views1 answer
Postgressql uuid
SQL
0 vote232 views1 answer
How to print mysql query of codeigniter query builder
SQL
1 vote255 views2 answers
Postgresql check privileges on schema
SQL