title: How to find source of 'No Join Predicate'
body: <p>I've got a ridiculously massive query generated by business objects web intelligence against a SQL server database for a budget system.  A report developer has created this query in the GUI and has found that it never completes.  I let it run last night and it ran for 7 hours before our servers rebooted for windows updates.</p>
  
  <p>I took a look at the explain plan in sql and found a few warning on a few 'Nested Loops (Inner Join) steps - two of these warnings fee into 3rd to last step.  The warning is 'No Join Predicate'.  </p>
  
  <p>The other note I have on this is that the query contains this in the where clause:</p>
  
  <pre><code> BF_FUND.CD  IN  ('0105','0101')
  </code></pre>
  
  <p>If you only put one fund code in there, it runs fine - so somehow adding the second code is making things go cartesian on us (maybe, this is what would happen with no join predicate).</p>
  
  <p>Any recommendations on how to track this down? 790 lines of wonderful SQL to wade through, with nothing but join after join.  </p>
  
  <p>Could the explain plan point to a specific area?</p>
  
  <p>Thanks for your assistance.</p>
  
  <hr>
  
  <p>Edits:</p>
  
  <p>Can't post the query, security thing and it's much to large to obfuscate.  And I wouldn't want to make anyone look at it.</p>