DELETE  FROM User2Group INNER JOIN UserGroupList
 ON
  User2Group.UserGroupSID = UserGroupList.SID
 INNER JOIN Servers
 ON
  UserGroupList.DomainController = Servers.Server
 AND Servers.DomainName = 'DOMAIN';

---

 Comments and Workarounds

---

Problem was with the join optimization attempting to flip around these joins, thus causing a problem with the driver table being used for the deletion of records. The workaround was to stick a NOJOINOPTIMIZE clause at the end of the statement.

---

 Resolution

---

Fixed Problem on 2/26/2002 in version 3.07 build 1