On 04/02/2012 02:55 PM, Reindl Harald wrote:
>>  delete from dbmail_headervalue where id not in (select headervalue_id from 
>> dbmail_header);


correct me if I'm wrong but last I checked neither MySQL nor PostgreSQL
support deleting rows selected in a sub-query.



-- 
________________________________________________________________
Paul J Stevens        pjstevns @ gmail, twitter, skype, linkedin

  * Premium Hosting Services and Web Application Consultancy *

           www.nfg.nl/i...@nfg.nl/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to