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 WHE

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 AN