Since MySQL doesn't do subselects, any ideas how I could pull this off in MySQL maybe with temp tables or something?
SELECT * FROM Inventory
WHERE (((Inventory.inventoryID) Not In (select inventoryID from inventory_assignments where date_in is null)));
