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