Re: Joined deletes but one table being a subquery.

> I apologize for the silence.
> 
> t_a as been created as 
> 
> CREATE TABLE t_a as  SELECT userid,category_id from eyp_listing where userid=21742 and size ilike '%WEBFL%'
> EXCEPT SELECT userid,category_id from company_export_profile where userid=21742 ;
> 
> so the subquery is basically 
> 
> ( SELECT userid,category_id from eyp_listing where userid=21742 and 
>  size ilike '%WEBFL%' EXCEPT SELECT userid,category_id from company_export_profile
>  where userid=21742 )
> 
> 
> regds
> mallah.
What about this?
delete from eyp_listing where exists (select * from  eyp_listing el  left join company_export ce using
(userid,category_id)where el.userid=21742 and size ilike '%WEBFL%' and ce.userid is null  and
el.userid=eyp_listing.userid and el.category_id=eyp_listing.category_id);
 

It should be solution, but not the answer for your question...
How did you use that sub-select, so it didn't work?

Regards,
Tomasz Myrta