We would definitely need more information to help you
Please explain the issue a bit more and also provide the DDL of the tables involved, some sample data and the expected results based on the sample data
If you are not sure about how to do this, please check the link in my signature
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/