Query help list

[Steven Low]

Resolved
Resolved
Resolved

 

[cjard]

SELECT 
  dept.*
FROM
  dept
  LEFT OUTER JOIN
  emp
  ON
    emp.deptNo = dept.deptNo
WHERE
  emp.deptno IS NULL
ORDER BY 
  dept.deptno

 

[Steven Low]

Resolved

Hi cjard

Thanks for that. Got it working thanks to you.