Update Query Returns Nothing

[kammsba]

I'm not getting any results. No error messages.

UPDATE History
SET DistrictNameID =
(SELECT SchoolDistrictNameID FROM dbo_Client
WHERE ClientHistoryID > 1 AND History.Member_ID = dbo_Client.ClientHistoryID);


This hasn't worked, either:

UPDATE History INNER JOIN dbo_Client ON History.Member_ID=dbo_Client.ClientHistoryID SET History.DistrictNameID = dbo_Client.SchoolDistrictNameID;


Neither has this:

UPDATE History
SET DistrictNameID = dbo_Client.SchoolDistrictNameID
FROM History, dbo_Client
WHERE dbo_Client.ClientHistoryID > 1
AND History.Member_ID = dbo_Client.ClientHistoryID

Any suggestions?

 

[dodge20]

Try this, it seems to work when I have this problem

UPDATE History
SET DistrictNameID =
(SELECT SchoolDistrictNameID FROM dbo_Client
WHERE ClientHistoryID > 1 AND History.Member_ID = dbo_Client.ClientHistoryID)
where History.Member_ID in
(select ClientHistoryID from dbo_Client); Dodge20