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 votes245 views2 answers
Find mysql version linux
SQL
0 vote221 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
14 votes245 views2 answers
Oracle add attribute to table
SQL
10 votes235 views6 answers
Between sql
SQL
0 vote238 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote227 views1 answer
Systemverilog unique constraint unique values
SQL
7 votes228 views2 answers
Sql server drop temp table if exists
SQL
3 votes245 views2 answers
Df to sql pandas sql achemy
SQL
10 votes238 views2 answers
Show tables in schema oracle
SQL
25 votes254 views5 answers
Date in mysql
SQL