Samuel

 Profile Answers by Samuel Questions by Samuel

• Oct 27th, 2005

 

select emp_id from employee a,department b where b.dept_code =* a.dept_code;

vardhan_81

 Profile Answers by vardhan_81 Questions by vardhan_81

• Nov 9th, 2005

 

IT IS THE ANSWER

SELECT EMPNO FROM EMP WHERE DEPTNO NOT IN(SELECT DEPTNO FROM DEPT);

Kiran Bondre

• Jul 29th, 2006

 

This is the query when there is no parent-child relationship between tables.

select ename,emp.deptno from emp,dept
where dept.deptno!=emp.deptno;

Laxmi Prasad

• Apr 2nd, 2007

 

select e.ename,e.deptno from emp as e,dept as d
where d.deptno=e.deptno and e.deptid not in select deptid from emp ;

M.Nagaselvam

• Nov 4th, 2007

 

SELECT e.ename,e.deptno,d.deptno FROM emp e,dept dWHERE d.deptno=e.deptno AND e.deptid NOT IN(40,50,60) ;

zdmytriv

 Profile Answers by zdmytriv 

• Jan 26th, 2008

 

SELECT Emp.Name FROM Emp WHERE ((SELECT COUNT(Dept.DeptNo) FROM Dept WHERE (Dept.DeptNo == Emp.DeptNo)) == 0)

nis1981

 Profile Answers by nis1981 

• Aug 3rd, 2008

 

select emp_name
from emp
where dept_no not in (select dept_no from dept)

srividhya_85

 Profile Answers by srividhya_85 Questions by srividhya_85

• Aug 5th, 2008

 

Select emp_name
from emp a
where not exists(select 1
                            from dept b
                           where a.dept_no = b.dept_no)

jayshree13

 Profile Answers by jayshree13 Questions by jayshree13

• May 13th, 2011

 

select e.ename,e.deptno,d.deptno from emp e,dept d where e.deptno=d.deptno(+);