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

6 votes336 views1 answer
To count number of rows in SQL table
SQL
2 votes347 views1 answer
When matched in sql server
SQL
1 vote295 views1 answer
Ms sql how to see active job current run time
SQL
0 vote352 views1 answer
Create database store
SQL
0 vote350 views1 answer
Python connect microsoft sql server
SQL
13 votes376 views3 answers
Insert mysql ifile nto database
SQL
0 vote437 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote335 views1 answer
Sql server inner join convert collation
SQL
2 votes460 views1 answer
Ssh mysql port forwarding
SQL
1 vote360 views1 answer
Quit mysql
SQL