Have you read this article?

http://msdn.microsoft.com/en-us/library/ms345137.aspx

i think you can write the query in the new syntax much more clearly and easily (if you are using SQL Server 2005)