inner join in oracle 8

giovamc
giovamc used Ask the Experts™
on
Hello I am new wroking in Oracle, so I want to know if the inner join clause work in Oracle 8.
Thanks a lot

Giova
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
You can use the "inner join" keyword in Oracle from Version 9
onwards. In previous versions you need to use the old Oracle syntax.


New syntax (Oracle9):

SELECT * FROM T1 INNER JOIN T2 ON T1.C1 = T2.C3


Old syntax (Oracle8):
 
SELECT * FROM T1, T2 WHERE T1.C1 = T2.C3

You can use
select * from T1,T2
where T1.C1(+)=T2.C3

where T1 and T2 are table names and C1 and C3 are columns

Hope this is OK with you

Commented:

The syntax using a "(+)" in the join condition is an outer join in Oracle.
For innerjoins you have to join without "(+)".
Hi ubasche
thx for clearing my fundamentals

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial