Třídová akce

Kód:

20

Tělo:

SELECT
 Max(A.store_id) as Store_ID,
 Max(ST.code) as Store_Code,
 Max(ST.name) as Store_Name
FROM
  POSDocuments2  A
  left join POSDocuments PD on PD.id = A.parent_id
  left join stores ST on ST.id = A.store_id
WHERE
  A.id like :SiteMask and
  A.OrderFinished = 'N' and
  ((A.orderkind = 2) and
   ((A.quantity>0) or
    (A.orderwastequantity>0)))  and
  pd.opened='N'
group by
  A.store_id
  

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