Objektová akce

Kód:

1

Tělo:

SELECT '0P030WWSAN54ZBUSRIMUFXOUV4' CLSID, 'Picture_ID' FieldName, NULL Firm_ID, Parent_ID Person_ID
FROM PersonPictures
WHERE Picture_ID = :OBJID

UNION ALL

SELECT 'FOHO1MV12RIOVGX3VOWKQORLCS' CLSID, 'Picture_ID' FieldName, NULL Firm_ID, E.Person_ID Person_ID
FROM EmployeePictures EP
JOIN Employees E ON EP.Parent_ID = E.ID
WHERE EP.Picture_ID = :OBJID

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