Answers for "on clause in sql"

SQL
0

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
Posted by: Guest on June-15-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language