use ItemMonster; update ItemMonster set AssociationId = 327 where AssociationId = 879; Go Delete from Association where AssociationId = 879;