Err, what????
That now doesn't match the query you posted (which returns only two columns) and is the result that you're asking for. If you already have that result, why are you asking for help in getting it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability