Objektová akce

Kód:

16

Tělo:

SELECT 1 
FROM GlobData 
WHERE EXISTS (
  SELECT 1
  FROM ReceivedOrders A
  JOIN ReceivedOrders2 A2 ON A2.Parent_ID = A.ID
  LEFT JOIN StoreCardDRCArticles SCDA ON SCDA.Parent_ID = A2.StoreCard_ID 
    AND SCDA.Country_ID = A.VATCountry_ID AND SCDA.DRCVATMode = 'A' 
  WHERE A.ID = :OBJID
    AND COALESCE(SCDA.DRCArticle_ID, A2.DRCArticle_ID) IS NOT NULL
)

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