SQL left outer join to find not in 3 tables
<p>I'd like to get a count of items not in 3 tables. The third table is in another database and should only be for producer_ID 139.
Run as this I get 859 as a count:          </p>

<pre><code>        SELECT count(item.item_ID) as itemcount 
        FROM   item
        LEFT OUTER JOIN item_Subject
          ON (item.item_ID = item_Subject.item_ID)          

        LEFT OUTER JOIN item_Category
          ON (item.item_ID = item_Category.item_ID)

        LEFT OUTER JOIN DATABASE2.dbo.item_SuperCategory
          ON (item.item_ID = DATABASE2.dbo.item_SuperCategory.item_ID 
               and  DATABASE2.dbo.item_SuperCategory.Producer_ID = 139)  

          WHERE item_Category.item_ID IS NULL
          and item_Subject.item_ID IS NULL  
          and DATABASE2.dbo.item_SuperCategory.item_ID IS NULL
</code></pre>

<p>But if I take out the <strong>DATABASE2.dbo.item_SuperCategory.Producer_ID = 139</strong> and run I get only 23.  I expected the number to be reduced, not increased.  What is wrong?</p>