Do joins exist

[Diodin]

Hi, I'm new with Oracle. I always used Microsoft Access to create databases. Now I need to use Oracle and it's going fine. The only thing I can't find in Oracle is de conmmand (INNER) JOIN. Dos it exist in Oracle and if it doesn't how should I create inner joins.

P.S. I need Oracle 8. On the site of Oracle I can only find Oracle 8i. Is there a place where I can download Oracle 8.

 

[lweng]

I don't understand the INNER JOIN on your post, does it means self join? If it is, see the example:
Join a table itself
Select worker.ename || 'work for '|| manager.name
From emp worker, emp manager
Where worker.mgr = manager.empno;

You can download oracle 8 from //technet.oracle.com

 

[Guest_imported]

Inner Join is your basic join.
It is more like select column1..columnN from emp e, dept d
where e.deptno = d.deptno.
That's oracle's version of inner join.
sokeh