# 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