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

4 votes316 views2 answers
Select first and last row mysql
SQL
0 vote310 views2 answers
How to update the multiple rows in sql
SQL
-1 vote306 views1 answer
Ssms connect with connection string
SQL
1 vote306 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote306 views1 answer
Postgresql conectar
SQL
0 vote382 views1 answer
Selecting specific day in colum sql
SQL
1 vote319 views1 answer
Mysql return text after a final full stop
SQL
0 vote317 views1 answer
Xampp increame mysql speed
SQL
0 vote337 views1 answer
T-sql email validation
SQL
2 votes325 views2 answers
Postgres drop column if exists
SQL