8 lines
288 B
SQL
8 lines
288 B
SQL
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
|