Re: [SQL] Joined deletes but one table being a subquery.

[Tomasz Myrta]

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend