I'm sure you could. Here is what I wrote to show which modifiers were rung in under which main item:
SELECT DISTINCT
trans_dtl.business_date AS business_date,
trans_dtl.chk_seq AS ticket_id,
vta.C_chk_num AS chk_num,
dtl.dtl_seq AS dtl_seq...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.