[ale] delete rows in mysql

[Chris Fowler]

On Wed, 2010-05-05 at 15:19 -0400, James Sumners wrote:
> I guess I started down the subquery path because you were leading ;)
> 
> Let's simplify this some:
> 
> DELETE FROM  trigger USING trigger INNER JOIN trigger_group_map WHERE
> trigger.trigger_id = trigger_group_map.trigger_id AND
> trigger_group_map.trigger_group_id = 3;

Wow.  Works great.