Objektová akce

Kód:

4

Tělo:

SELECT
  '05', CR2.Parent_ID
FROM
  StoreDocuments2 SD2
  join CashReceived2 CR2 on CR2.ProvideRow_ID = SD2.ID
WHERE
  SD2.Parent_ID = :OBJID

UNION

SELECT
  '03', II2.parent_id
FROM
  StoreDocuments2 SD2
  join IssuedInvoices2 II2 on II2.ProvideRow_ID = SD2.ID
WHERE
  SD2.Parent_ID = :OBJID  

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