Re: sub select

[Dan Nelson]

In the last episode (May 18), pdube said:
> anyone knows why
> select code_dept from dept where code_dept not in (select dept_emp from
> employe);
> dosen't work??  or where i can find a error section where the number and
> the explain was there???

SELECT code_dept FROM dept LEFT JOIN employe ON code_dept=dept_emp
    WHERE dept_emp IS NULL;