Třídová akce

Kód:

23

Tělo:

SELECT A.ID as ID,  B.ID as UnitID, B.Code as UnitCode
FROM StoreCards A, StoreUnits B

WHERE (Upper(A.Name collate pxw_csy) = :CodeName or Upper(A.Code collate pxw_csy) = :CodeName) 
       and (A.Hidden = 'N') and
       (B.Parent_ID = A.ID) and (b.code = a.MainUnitCode)

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