> What? No. NoSQLs don't help with joins, as they don't have them at all. Meaning every "join-like" has to be client side and entails transmitting stuff to the client, which is even worse than temporary tables.
I have worked with two NoSQL databases and both have support for basic joins. Not that it's needed very often.