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

25 votes325 views1 answer
How to update an attribute in MySQL
SQL
1 vote339 views1 answer
Sql select sum group by id laravel
SQL
36 votes296 views6 answers
Rename table sql
SQL
3 votes291 views4 answers
Psql list tables in schema
SQL
0 vote312 views1 answer
T-sql update table variale
SQL
0 vote311 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote298 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote266 views1 answer
Mysql autoincrement valor inicial
SQL
4 votes335 views4 answers
Mysql get date from datetime
SQL
8 votes315 views4 answers
Reset SQL auto increment
SQL