select pd5.vatrate, sum(pd5.tamount) as amount, sum(pd5.tamountwithoutvat) as amountwithoutvat from posdocuments PD join posdocuments5 pd5 on pd.id=pd5.parent_id where PD.posshift_id=:POSShift_ID and PD.opened='N' group by pd5.vatrate, pd5.vatrate_id
Generated by ABRA Software a.s. 27.10.2021 16:34:30