You need to do an Outer Join, something like
Select FolderName
,COALESCE(Permission,'None') Permission
--,IsNull(Permission,'None') Permission --Alternate to COALESCE
From Folder f
LEFT OUTER JOIN [Permissions] p
on f.FolderId=p.FolderId
_________________________________________________________________________
SSC Guide to Posting and Best Practices