=?ISO-8859-1?Q?J=E9r=F4me?= Calais <[EMAIL PROTECTED]> writes:
> I am encountering problems with IN selections.
> I am trying this query :
> delete from status where status_id not in (select distinct status_id
> from company);
I'll bet the sub-select yields some NULL rows? If so, this is not a
bu
Jérôme Calais writes:
> delete from status where status_id not in (select distinct status_id
> from company);
>
> "status_id" is a foreign key in "company".
>
> It does not delete any records from status table whereas it should
> because the sub query returns some records.
There are probably null
I am encountering problems with IN selections.
I am trying this query :
delete from status where status_id not in (select distinct status_id
from company);
"status_id" is a foreign key in "company".
It does not delete any records from status table whereas it should
because the sub query returns
