Menu item no, isim, grup ve fiyatını sorgulayan sql kodu
MICROS | 20.04.2026
SELECT a.obj_num as no,a.name_1 as isim,b.name as family,c.name as major,d.preset_amt_1 as fiyat FROM "micros"."mi_def" as a
inner join "micros"."fam_grp_def" as b
on a.fam_grp_seq=b.fam_grp_seq
inner join "micros"."maj_grp_def" as c
on a.maj_grp_seq=c.maj_grp_seq
inner join "micros"."mi_price_def" as d
on a.mi_seq=d.mi_seq
order by a.obj_num;
inner join "micros"."fam_grp_def" as b
on a.fam_grp_seq=b.fam_grp_seq
inner join "micros"."maj_grp_def" as c
on a.maj_grp_seq=c.maj_grp_seq
inner join "micros"."mi_price_def" as d
on a.mi_seq=d.mi_seq
order by a.obj_num;
output to 'd:\menü.txt'