Re: Query Help Needed

Hi Greg,

the second issue may be solved by something like:

Select
e.name,
e.empno
from
emp e,
(

select
empno
from
(select

count(deptno) numdept,
empno
from
yourtable
group by
emp,deptno
) a
where
a.numdept > 1
) b
where
e.empno=b.empno
;

hth

Matthias Received on Fri Sep 07 2001 - 10:16:12 CEST