SELECT DISTINCT F2.ID FROM Suppliers S JOIN Firms F ON F.ID = S.Firm_ID OR F.Firm_ID = S.Firm_ID JOIN Firms F2 ON F2.ID = coalesce(F.Firm_ID, F.ID) OR F2.Firm_ID = coalesce(F.Firm_ID, F.ID) WHERE S.StoreCard_ID = :StoreCard_ID
Generated by ABRA Software a.s. 27.10.2021 16:34:12