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 vote190 views1 answer
C# check if mysql query modified rows
SQL
2 votes182 views1 answer
Oracle sql drop column if exists
SQL
0 vote233 views2 answers
Sql update multiple tables
SQL
0 vote237 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
3 votes196 views1 answer
Oracle sleep
SQL
0 vote183 views1 answer
Remove binlog mysql
SQL
0 vote205 views1 answer
Compression of dabatase mysqldumo
SQL
2 votes199 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote201 views1 answer
Select row with latest date mysql
SQL
0 vote186 views1 answer
Oracle search columns in schema
SQL