> 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