Lowell (9/19/2012)

---

there's two ways to do it;

one witht he proprietary SQL syntax, and another with a correlated query:

--SQL Server UPDATE FROM syntax

UPDATE [Projects]

SET Projects.Closed = Projects3.Closed

FROM [Projects3]

WHERE Projects3.Name =...