Do you really think you gave us enough to go on with that short one-liner to be able to assist you?? No table structures, no query, no error message - nothing. You gotta help us help you!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service