Though I know the drawbacks of NOLOCK, it can't be avoided in our case. So, excuse me for that.

And regarding this post, I know that logically all 3 queries are same, but I'm little confused about how SQL Server is handling the JOINS in these 3 queries!!!

And if it doesn't matters then why I should not use Query 2 or 3 everywhere!!!