Třídová akce

Kód:

56

Tělo:

select max(su.name) as Name, count(PD.id), sum(pd.amount) as amount
from
  posdocuments pd
  join securityusers SU on SU.id=pd.correctedby_id
where
  PD.posshift_id=:POSShift_ID and
  PD.opened='N'
group by
  PD.correctedby_id, su.name
order by su.name

Generated by ABRA Software a.s. 27.10.2021 16:34:30