select
A.ID
from
AssetInvListCards A
join AssetInv I on I.ID = (A.AssetInv_ID) and (I.InventoryState = 1)
where
((A.AssetCard_Type = :AssetCard_Type) and (A.AssetCard_ID = :AssetCard_ID))
Generated by ABRA Software a.s. 27.10.2021 16:34:24