Reymundo,
Try using a parameterized view. It won't be a memory hog if you'll just be using a table or two. For optimization create indexes for the JOIN statement. The view like any other table could be updatable, depending on your requirements. :}