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 vote138 views1 answer
Create table tablename as select * from tablename
SQL
0 vote146 views1 answer
Sql trying to delete database in use
SQL
1 vote167 views1 answer
Select inside insert query
SQL
1 vote143 views1 answer
How to open closed port mysql in ubuntu
SQL
3 votes132 views1 answer
MySQL DELETE JOIN
SQL
6 votes241 views3 answers
Psql show columns of table
SQL
5 votes160 views1 answer
Sql table columns
SQL
0 vote149 views1 answer
Why mysql is used?
SQL
0 vote160 views1 answer
Search In the Data using ObjectName
SQL
1 vote144 views1 answer
Xampp import sql file command line
SQL