Re: deleting records that match other table

On Wed, 08 Mar 2006 17:40:34 -0800, MSWEENEY wrote:

> delete from TABLE_A
> WHERE [A].[NUMBER] = [B].[NUMBER]
You're aware that "NUMBER" is a reserved word and, as such, an inappropriate name for a column? You should find better names for those columns, like SELECT, COMMIT or SET.

-- 
http://www.mgogala.com