Re: DELETE based on JOIN

2006-06-27 Thread Peter Brawley
Jesse wrote: I need to delete some records based on a JOIN relation. The following works in Microsoft SQL Server, and the syntax appears to be correct for MySQL, but it reports "syntax..near 'DELETE FROM ConvInvDet FROM ConvInvDet H...". What's the proper way to format this for MySQL? DELETE

DELETE based on JOIN

2006-06-27 Thread Jesse
I need to delete some records based on a JOIN relation. The following works in Microsoft SQL Server, and the syntax appears to be correct for MySQL, but it reports "syntax..near 'DELETE FROM ConvInvDet FROM ConvInvDet H...". What's the proper way to format this for MySQL? DELETE FROM ConfInvD