G
Guest
SELECT Ingredient,MenuItem, NumberofOunces
FROM tblIngredients
UNION SELECT ItemName, Ingredients, NumberofOunces
FROM tblInHouseReceipt;
This is a copy of my Union Query. I have Ingredient that are made from
scratch. out sauce is made in house by when I put it in the ingredients table
I called it sauce. In my in house rec. I listed the ingredients that go into
the sauce. Now I want to join the two tables so I i can cost out the sauce
with in my ingredients table. This query gives me all the reocrd and I only
want those that match.
Please Help
FROM tblIngredients
UNION SELECT ItemName, Ingredients, NumberofOunces
FROM tblInHouseReceipt;
This is a copy of my Union Query. I have Ingredient that are made from
scratch. out sauce is made in house by when I put it in the ingredients table
I called it sauce. In my in house rec. I listed the ingredients that go into
the sauce. Now I want to join the two tables so I i can cost out the sauce
with in my ingredients table. This query gives me all the reocrd and I only
want those that match.
Please Help