title: LEFT LOOP JOIN in SQL Server 2008
body: <p>I am getting a warning message when I run even a simple select query against a view saying </p>
  
  <blockquote>
    <p>The Join Order has been enforced because a local join hint is used.</p>
  </blockquote>
  
  <p>The view has been modified recently and the change was using Left loop join for one of the joins from before. </p>
  
  <p>Can anyone please tell me how to suppress this warning message?</p>
  
  <p>Please provide me sample examples.</p>
  
  <p>Thank You.</p>