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

2 votes346 views1 answer
Oracle run_duration to number
SQL
0 vote312 views1 answer
Import sql in postgresql
SQL
0 vote316 views1 answer
To_date sql
SQL
6 votes310 views2 answers
Where clause in sql
SQL
2 votes319 views1 answer
Q operator in sql
SQL
1 vote293 views1 answer
Set mysql mode global query
SQL
0 vote300 views1 answer
Sql beginning of previous month
SQL
0 vote318 views1 answer
Wordpress database query change url
SQL
0 vote315 views1 answer
How to insert a uniqueidentifier in sql
SQL
3 votes314 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL