Do you need areas marked on your map by npc before you can go there?
There are a few plot related areas which remain sealed until the appropriate quest opens them. You do not have to join the thieves' guild; that will just get the location you already found marked on your map and give you access to the poor quarter sewer entrance. There are several non-essential quests that require joining the guild, though (not to mention loot).