exists "join"-operation?

Hello,

does "join"-operator in ORACLE exist? Or are all joins in SQL-statements implementated in the where-clause ?

example:

           select .... where table1.tab1_ID = table2.tab2_ID

          does something like this exist:
           select  .... join table1.tab1_ID on  table2.tab2_ID

         ?????????????


efficiency:
             if exist so, which is the most efficient method ?

thank you for help
Ekkard Received on Wed Mar 10 1999 - 11:38:29 CST