sql SELECT DocumentID, FileLocation, FileName, FolderID, OnDisc, ModuleID, ContentType, Coalesce(Size,0) as Size, DownloadSpecID, Type FROM fbvDocumentAllBlobNames b LEFT OUTER JOIN cvtContentTypes c ON b.contenttype = c.contentID WHERE BlobID='9632'