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