So i make a console application in c# and make odb connection on micros 3700 database. With tool Sybase Central i figure out most everything but i miss this..
Need this QUERY for this kind of structure:
Item_2
Modifier group_1
modifier_1
modifier_2
modifier_3
Modifier group_2
modifier_1
modifier_2
modifier_3
Item_2
....
So what i need is; My item BURGER have modifiers (requeired or not requeired) and they are in some modifier group.
I need 1,2,3 sql for this and key how to bond that because now what i saw in mi_def i have modifiers but don't know the bond betwean Item-Burger(example) and (mit, rare, medium) modifier - in some group.
PLS HELP .. This is first of many questions.
Need this QUERY for this kind of structure:
Item_2
Modifier group_1
modifier_1
modifier_2
modifier_3
Modifier group_2
modifier_1
modifier_2
modifier_3
Item_2
....
So what i need is; My item BURGER have modifiers (requeired or not requeired) and they are in some modifier group.
I need 1,2,3 sql for this and key how to bond that because now what i saw in mi_def i have modifiers but don't know the bond betwean Item-Burger(example) and (mit, rare, medium) modifier - in some group.
PLS HELP .. This is first of many questions.