SQL Joins

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

SQL Joins

Post by admin »

select * from emp;

select * from dept;

select e.* from emp e
inner join dept d on e.deptno = d.deptno

select e.* from emp e
left join dept d on e.deptno = d.deptno

select e.* from emp e
left outer join dept d on e.deptno = d.deptno

select e.* from emp e
right join dept d on e.deptno = d.deptno

select e.* from emp e
right outer join dept d on e.deptno = d.deptno

-- Self Join

select a.empno, a.ename, a.job, b.ename Manager from emp a
left join emp b on a.mgr = b.empno
order by a.mgr;
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests