This is a cross post.

http://www.sqlservercentral.com/Forums/Topic1827737-145-1.aspx">

http://www.sqlservercentral.com/Forums/Topic1827737-145-1.aspx

Rather than posting the same thing in multiple spots, people will better serve you better if you help them to help you. In both of these threads you are asked to give table definitions, sample data, etc... See if this article illustrates better the ask

http://www.sqlservercentral.com/articles/Best+Practices/61537/"> http://www.sqlservercentral.com/articles/Best+Practices/61537/

It begins with the create table script(s), then on to sample data and anything else that may be needed. In your case it involves the definition of a view I believe.

BTW, cross posting is frowned upon in the forum.