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?