USING: SQL Server 2005
I'm used to seeing Joins constructed using what I'll call the "Traditional" format:
Apparently there is an "Alternative" format that allows you to nest the joins:Code:SELECT * FROM tbl1 INNER JOIN tbl2 ON tbl1.field1 = tbl2.field1 INNER JOIN tbl3 ON tbl2.field2 = tbl2.field2
Besides the maintenance ick factor that I encounter when ever I see this construct... does any one know if there is a performance difference between the two?Code:SELECT * FROM tbl1 INNER JOIN tbl2 INNER JOIN tbl3 ON tbl2.field2 = tbl2.field2 ON tbl1.field1 = tbl2.field1
I've got a query that is using this alternative construct, before I got in there deciphering what the joins really are, and re-arranging them to my liking, I'm curious to know if there would be any benefit to do so.
-tg




Reply With Quote
