join and other magic