troubleshooting Question

Need help with a query

Avatar of RadhaKrishnaKiJaya
RadhaKrishnaKiJaya asked on
Microsoft SQL ServerVisual Basic.NET
3 Comments1 Solution142 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros