SELECT doc.ContentID FROM tbl_DOC_Documents doc WHERE DocID = ; SELECT RTRIM(tbl_FSC_Content.MainFolder) + '\' + COALESCE (LTRIM(tbl_FSC_Content.SubFolder), '') + '\' + tbl_FSC_Content.FileName AS ResourcePath, tbl_FSC_Content.FileName FROM tbl_FSC_Content INNER JOIN tbl_FSC_SubFolders ON tbl_FSC_Content.SubFolder = tbl_FSC_SubFolders.SubFolderCode AND tbl_FSC_Content.ContentID =