title: Microsoft Access 97/XP Left Join On Multiple Columns Fails - Vista/7 are fine
body: <p>Im trying to do a left join on two tables to get all values that do not exist in table 2 or have a status of null:</p>
  
  <p>Table 1 has ROID as long</p>
  
  <p>Table 2 has ID long, Type long, and Status text.</p>
  
  <p>This works fine on Vista and Win 7 (I get all the records that do not exist in V), but I get no records on XP, </p>
  
  <pre><code>  SELECT roid
    FROM
    wo AS w LEFT JOIN VFlag As V ON (w.roid = V.ID AND V.Type = 2)
    WHERE
    (V.Status is Null) 
  </code></pre>
  
  <p>When I remove the V.Type = 2, it works fine on XP/Vista/7, but I need to qualify on Type as well:</p>
  
  <pre><code>SELECT roid
    FROM
    wo AS w LEFT JOIN VFlag As V ON (w.roid = V.ID)
    WHERE
    (V.Status is Null)  
  </code></pre>
  
  <p>This is both in VB6 using ADO and VisData. Trying WHERE isnull(V.Status) did not make any difference. XP machines (two tested on) are SP3.</p>