select e.ID, e.NAME, d.DEPTNAME
from EMP e,
DEPT d
where e.DEPTNO = d.DEPTNO and
(e.NAME = 'JOSE' or
d.DEPTNO = 50);
-Original Message-
Sent: Wednesday, October 29, 2003 12:54 PM
To: Multiple recipients of list ORACLE-L
Hi,
I wonder if there's a bette
from basic set theory:
union = OR
intersect = AND
select e.id, e.name, d.deptname from emp e, dept d
where e.deptno=d.deptno and e.name='JOSE'
or d.deptno = 50;
>
> From: "Linda Wang" <[EMAIL PROTECTED]>
> Date: 2003/10/29 Wed PM 12:54:26 EST
> To: Multiple recipients of list ORACLE-L <[EM
I don't see why would query with multiple unions necessarily degrade performance,
but here is another way for writing your query:
select e.id, e.name, d.deptname from emp e, dept d
where e.deptno=d.deptno and ( e.name='JOSE' or d.deptno=50)
/
That would be a union of all employees from the depart