in case you are chatting precisely about SQL Server, then you ought to certainly be utilizing the INNER JOIN syntax. besides remaining (particular viewpoint notify!) simpler to browse and more obvious in intent, You can find, as of SQL Server 2005, no equivalent syntax for outer joins. I love my task because the databases is the most worthy detail