Loading to RAM vs Querying to get all

The title of the post is pretty streight forward. Here is a problem i face every day and i believe every developer, that has something to do with databases, does. When you need a result set that has to be created out of sever or eight tables what do you do? Do you...