heading wise value bind

Oct 3 2016 1:12 AM

Hello guys, I have two table

1)tblVariety

DID Dishtype AddedDate

DT001 Veg 2016-09-30

DT002 Non-Veg 2016-09-30

DT003 Coffee 2016-09-30

DT004 Cakes 2016-09-30

2)tblProducts

ProId ProductName ProductDescription ProductPrice VNV

MN001 Dosa South indian famous food 60 Veg

MN002 Meals Rice and chenna fry and more indian culture 150 Veg

MN003 Burger Its chines made culture and fastfoods 80 Veg

MN004 Chettinadu chicken Its very tasty and spicy 100 Non-Veg

MN005 chicken Loipop this chicken leg piece fry 120 Non-Veg

MN006 Grill chicken its very fry in grill machines 350 Non-Veg

MN007 choco cofee its hard choco and sweetest without milk 100 Coffee

MN008 Mintmojiti mint tast its feel fresh 100 Coffee

MN009 Straberry Milkshake Its healthy and sweetest items 150 Coffee

MN010 Home Strawberry its a sweetest and tasty 90 Coffee

MN011 Chocolate cake its a dark choco and soft emmy 300 Cakes

MN012 Mary Berry its formal and crunchi cake 200 Cakes

MN013 Buttar confetti its a milk mixed made cake 150 Cakes

I want output in:

Veg

Dosa Meals Burger

South indian famous food Rice and chenna fry and more indian culture cheinese ffood

60 150 80

Non-Veg

Chettinadu chicken

Its very tasty and spicy

100

Cofee

(values)...................................

Cakes

(Values).............................................

Any one please help me

Answers (9)