Re: inner join in Oracle

> col1 (+) = col2

To complete the story: above is a left join. An inner join would not have the (+), e.g.:

    from tableA a, tableB b
    where a.col1 = b.col2;

Arjan.

>> I created an inner join SQL statement in access but I noticed that the
>> statement will not work in oracle. Is there a particular way oracle
>> does this type of a join? I am going to explore other ways around it
>> for now, since there may be numerous ways of writing the same query.
Received on Wed Sep 16 1998 - 13:46:07 CDT