Resolved Resolved Resolved
Last edited by Steven Low; 04-05-2007 at 1:52 PM. Reason: Resolved
Code: SELECT dept.* FROM dept LEFT OUTER JOIN emp ON emp.deptNo = dept.deptNo WHERE emp.deptno IS NULL ORDER BY dept.deptno
SELECT dept.* FROM dept LEFT OUTER JOIN emp ON emp.deptNo = dept.deptNo WHERE emp.deptno IS NULL ORDER BY dept.deptno
DW1 DW2 DW3 DW4 DNU PQ
Hi cjard Thanks for that. Got it working thanks to you.
Forum Rules
Bookmarks