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 vote200 views1 answer
Mysql strict_trans_tables
SQL
1 vote232 views1 answer
Set statiscis on in sql server
SQL
0 vote222 views1 answer
Group by max date
SQL
2 votes234 views1 answer
Oracle Column Names of a table
SQL
0 vote182 views1 answer
How much table store postgres
SQL
8 votes184 views5 answers
Alter table add column with default value
SQL
0 vote176 views1 answer
Mysql isshow
SQL
1 vote182 views1 answer
Primary key with prefix sql
SQL
0 vote182 views2 answers
Sql use not in
SQL
0 vote208 views2 answers
Plpgsql
SQL