SELECT DV.VersionID, FF.NAme, ASSOCIATIONID, AA.ROFSTID, RODBID 
from DocVersions DV
JOIN Folders FF ON FF.FolderID = DV.FolderID
JOIN Associations AA ON DV.VersionID = AA.VersionID
JOIN ROFSTS RF ON RF.ROFSTID = AA.ROFSTID

Update Associations set ROFSTID = 4 where AssociationID = 3