Deleting from a table but specifying another..

I'm trying to remove rows from one table where a column matches another column in a seperate table.. I have mysql 3.22.32: DELETE TemporaryUsers_ToMessWith.* FROM TemporaryUsers_ToMessWith, Advantage_Backup WHERE Advantage_Backup.TempAccountNumber = TemporaryUsers_ToMessWith.TempAccountNumber

Re: Deleting from a table but specifying another..

Hi. On Mon, Oct 01, 2001 at 04:48:36PM -0400, [EMAIL PROTECTED] wrote: I'm trying to remove rows from one table where a column matches another column in a seperate table.. I have mysql 3.22.32: DELETE TemporaryUsers_ToMessWith.* FROM TemporaryUsers_ToMessWith, Advantage_Backup WHERE