It is certainly possible to stop you from joining the other i believe. You could also make a major negative disposition from the other guild.
As it stands now it should be nothing. Because the original morrowind didn't have the dark brotherhood and oblivion didn't have the morag tong. So my guess is there is nothing in the game to stop you from joining either. The people from the other guild probably won't even know.
again i am no expert