asked on

Need help with a query

Hi Experts,

I want to write a query to group the data by groupID.

GroupID GroupName MenuItemID MenuItemName
8 Cheese 25 Cheese Pizza (VEG)
8 Cheese 12 Bean & Cheese Quesadilla (GF & VEG)
8 Cheese 13 Bean & DF Cheese Quesadilla (GF, VEG, & V)
8 Cheese 26 Cheese Quesadilla (GF & VEG)
8 Cheese 28 Cheese Quesadilla w/ DF Cheese (GF, VEG, & V)
8 Cheese 27 Cheese Quesadilla (VEG)
8 Cheese 121 Vegetable Quesadilla (VEG)
8 Cheese 122 Vegetable Quesadilla w/ DF cheese (VEG & V)
18 Grilled Cheese 64 Grilled Cheese on GF Bread (GF & VEG)
18 Grilled Cheese 65 Grilled Cheese w/ DF Cheese (VEG & V)
18 Grilled Cheese 63 Grilled Cheese (VEG)

I want like this

Cheese
Cheese Pizza (VEG)
Bean & Cheese Quesadilla (GF & VEG)
...
...
Grilled Cheese
Grilled Cheese on GF Bread (GF & VEG)
Grilled Cheese w/ DF Cheese (VEG & V)

Thanks in advance.

Patrick Matthews

What you really need there is a report to display the data the way you want. Any of the major report packages would make this a fairly trivial exercise if you already have a query delivering the data as above.

ASKER CERTIFIED SOLUTION

PortletPaul

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

RadhaKrishnaKiJaya

ASKER

Thanks a lot!!