for anyone who is conversing specifically about SQL Server, then you need to surely be utilizing the INNER JOIN syntax. besides being (own view warn!) easier to go through plus much more crystal clear in intent, There may be, as of SQL Server 2005, no equal syntax for outer joins. I love my job as the databases will be the most precious factor in