title: Can't get outer join or notexists join to work in AX 2009
body: <p>I have a completely blank custom table (DatabaseLogFixLog) with only one field/column called "refRecId".  I am joining it to SysDatabaseLog (log).  The plan is to update SysDatabaseLog in batches, and as I update the SysDatabaseLog, I'll insert the recId of the row I updated.  My SysDatabaseLog has 3.7 million records in it.  I have tried both notexists join and outer join seen below.  What's wrong with my code?  Both just completely lock up my system, and the debugger will not get inside the loops.</p>
  
  <p><strong>Outer join:</strong></p>
  
  <pre><code>updateCounter = 10;
  while select forupdate log
      order by CreatedDateTime, RecId
      outer join databaseLogFixLog
      where databaseLogFixLog.RefRecId != log.RecId
  {
      counter++;
  
      if (counter &gt; updateCount)
          break;
  
      info(strfmt("%1", counter));
  }
  
  info(strfmt("Done updating %1", counter));
  </code></pre>
  
  <p><strong>Notexists join:</strong></p>
  
  <pre><code>updateCounter = 10;
  while select forupdate log
      order by CreatedDateTime, RecId
      notexists join databaseLogFixLog
      where databaseLogFixLog.RefRecId == log.RecId
  {
      counter++;
  
      if (counter &gt; updateCount)
          break;
  
      info(strfmt("%1", counter));
  }
  
  info(strfmt("Done updating %1", counter));
  </code></pre>