See the thread in todays postings 'RE:Help with paramaterized SQL View'. There is some good stuff in there. I would advise just playing around with the View designer and looking at the SQL code that it creates. In the long run what is unnatural will become second nature, or so they tell me. Good luck!
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!