You need to provide some DDL for this problem. How about some create table statements with actual column names and real data with expected results.
Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate
Forum Etiquette: How to post data/code on a forum to get the best help[/url]