Hello,
I am working on a school project in which i need to create a database for a restaurant chain. right now i have two table in which i input quotes for a specific category of ingredients from two different suppliers. I want a query which can identify which supplier is the overall cheapest and then populate a table with those ingredients and prices.
Thanks
I am working on a school project in which i need to create a database for a restaurant chain. right now i have two table in which i input quotes for a specific category of ingredients from two different suppliers. I want a query which can identify which supplier is the overall cheapest and then populate a table with those ingredients and prices.
Thanks