Re: inner join in Oracle

Opps, disregard that message. I just found another way to write the query. But, I would be curious to know if inner join exists in Oracle. I know that outer joins do exist denoted:

select * from table1, table2 where table1.id (+) = table2.id;

That is correct, right?
Oh well, thanks anyways
Kevin

Kevin Kirkpatrick wrote:

> 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.
> Thanks
>
> Kevin
Received on Wed Sep 16 1998 - 12:14:53 CDT