Re: Help with an Update Statment

Try this:

UPDATE tbl_Output
SET OfficerSID1 = (SELECT TOP 1 OfficerSID
FROM Co AS C
WHERE C.custID = tbl_Output.custID
ORDER BY OfficerRank, OfficerSID),
OfficerSID2 = (SELECT TOP 1 OfficerSID
FROM (SELECT TOP 2 OfficerRank, OfficerSID
FROM Co AS C
WHERE C.custID = tbl_Output.custID
ORDER BY OfficerRank, OfficerSID) AS T
ORDER BY OfficerRank DESC, OfficerSID DESC);

HTH,

Plamen Ratchev
http://www.SQLStudio.com
.