SQL Complicated Group / Join by Category
- by Mike Silvis
I currently have a database structure with two important tables.
1) Food Types (Fruit, Vegetables, Meat)
2) Specific Foods (Apple, Oranges, Carrots, Lettuce, Steak, Pork)
I am currently trying to build a SQL statement such that I can have the following.
Fruit < Apple, Orange
Vegetables < Carrots, Lettuce
Meat < Steak, Port
I have…