Don't compromise the design of your database just to have fewer tables and make the SQL easier/shorter... you will just be storing up problems that will have the potential to bite you later on.

If you think the SQL is to complex, then the advice from the previous post to create a VIEW is good advice.