Demaestro - 6:40 pm on Apr 19, 2011 (gmt 0)
Too be honest I don't see anything wrong with your code.
I wonder if the issue is funny/bad data.
Try this in PHPmyAdmin
**This will return vendors with no inventory record with a status of 1
select vendorid,vendorname from vendors where vendorid not in (select mfg from inventory WHERE status = 1)
Does it return anything?