Třídová akce

Kód:

6

Tělo:

select A.AssetInv_ID, A.Parent_ID from AssetInvListCards A
 join AssetInv AI on AI.ID = A.AssetInv_ID
 where
 (AI.InventoryState = 1) and 
 (A.AssetCard_Type = :AssetCard_Type) and (A.AssetCard_ID = :AssetCard_ID)
 union all
 select A.AssetInv_ID, A.Parent_ID from AssetInvListResults A 
 join AssetInv AI on AI.ID = A.AssetInv_ID
 where 
 (AI.InventoryState = 1) and 
 (A.AssetCard_Type = :AssetCard_Type) and (A.AssetCard_ID = :AssetCard_ID)  

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