Objektová akce

Kód:

9

Tělo:

SELECT {FIELDS} 
FROM MainInvProtocolRows A 
JOIN STORECARDS SC on SC.ID = A.Storecard_ID
WHERE A.Parent_ID =:OBJID and a.closed = 'N' and  
(      a.id in (select pipr.miprow_id
                 from partialinvprotocols pip
                 join partialinvprotocolrows pipr on pipr.parent_id = pip.id
                 where pip.mainprotocol_id = a.parent_id and
                       pip.closed = 'N'
               )
      Or
      a.id not in (select pipr.miprow_id
                     from partialinvprotocols pip
                     join partialinvprotocolrows pipr on pipr.parent_id = pip.id
                     where pip.mainprotocol_id = a.parent_id
               )
)
{ANDWHERE}
{ORDER_BY}

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