title: SQL Server 2008 R2 : Cross join with Where Vs Inner Join Performance
body: <p>As per this link :</p>
  
  <p><a href="http://technet.microsoft.com/en-us/library/ms190690%28v=sql.105%29.aspx" rel="nofollow">MSDN link</a></p>
  
  <p>It says that if a Cross join has where clause it behaves as a Inner join and returns the same result as a Inner join.</p>
  
  <p>I understand that part. But my question is when I am using a query cross join with a where condition and another query with Inner join with ON clause, both using the same relations and returning same data, will there be any difference in performance ?</p>
  
  <p>Will the performance be affected if a third/fourth table is joined with these two tables on INNER or LEFT OUTER JOIN ?</p>
  
  <p>I could not find a direct answer on the web addressing the same for SQL Server.</p>
  
  <ul>
  <li><p>Girija</p></li>
  <li><p>Girija</p></li>
  </ul>