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.mi_def m
left outer join micros.dly_sys_mi_ttl t
on m.mi_seq=t.mi_seq
where
t.business_date = (select business_datefrom micros.rest_status) GROUP BY obj_num, name_1
Left outer join gives you...
We do this all of the time. Have your cashiers set-up as a different employee class that are not pop-up employees and the other employees need to be set-up as pop-up employees. We have cashiers in our environment, and when they are logged in, they stay logged in until they log out. Managers...
We do this all of the time. Have your cashiers set-up as a different employee class that are not pop-up employees and the other employees need to be set-up as pop-up employees. We have cashiers in our environment, and when they are logged in, they stay logged in until they log out. Managers...
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.