Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Select A.DocumentID, A.RevisionID, MAX(B.RevisionDate) As [LastRevision]
From Documents A INNER JOIN Revisions B
ON A.RevisionID = B.RevisionID
GROUP BY A.DocumentID, A.RevisionID