Queries restricting found data

The WHERE clause must specify found objects only. Otherwise, all objects of that type in the database are returned instead of only the found records. These examples apply to formulas and items:


...f.formula_id = s.formula_id...
...i.item_code = s.item_code...