stagerman15
Programmer
I'm having a serious issue with certain items not appearing in the database when purchased. None of my beers are appearing in the report for today. This is the query that I'm using:
select m.obj_num, m.name_1, sum(t.price_1_sls_cnt) as count,
sum(t.price_1_sls_ttl) as total from micros.dly_sys_mi_ttl t, micros.mi_def
m where m.mi_seq = t.mi_seq and t.business_date = (select business_date
from micros.rest_status) GROUP BY obj_num, name_1
If anyone has an idea why some items appear but others do not, please let me know.
Thanks,
Todd
select m.obj_num, m.name_1, sum(t.price_1_sls_cnt) as count,
sum(t.price_1_sls_ttl) as total from micros.dly_sys_mi_ttl t, micros.mi_def
m where m.mi_seq = t.mi_seq and t.business_date = (select business_date
from micros.rest_status) GROUP BY obj_num, name_1
If anyone has an idea why some items appear but others do not, please let me know.
Thanks,
Todd