Avatar of RadhaKrishnaKiJaya
RadhaKrishnaKiJaya
 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.
Microsoft SQL ServerVisual Basic.NET

Avatar of undefined
Last Comment
RadhaKrishnaKiJaya

8/22/2022 - Mon
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

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
RadhaKrishnaKiJaya

ASKER
Thanks a lot!!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23