List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 18 1999 5:29pm
Subject:Re: sub select
View as plain text  
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;
sub selectpdube18 May
  • Re: sub selectChristian Mack18 May
  • Re: sub selectDan Nelson18 May