I have an Access database with tables,queries, forms etc. I would like to get some data out of a query.
This is my initial cut:
SELECT RECIPE.TITLE, INGREDNT.NAME,
FROM RECIPE, INGREDNT, QUANTITY,
RECIPE.RECIPE = QUANTITY.RECIPE AND
INGREDNT.INGREDIENT = QUANTITY.ITEM AND
QUANTITY.ITEM = ShowUnitRecs.ITEM AND
RECIPE.RECIPE = '000001';
Where RECIPE, INGREDNT and QUANTITY are tables and
ShowUnitRecs is a Query.