Objektová akce

Kód:

2

Tělo:

SELECT A.ID, A.Place2_ID As OtherPlace_ID, P.NAME As Name
  FROM MLBDistances A
  JOIN MLBPlaces P ON P.ID=A.Place2_ID
  WHERE (A.Place1_ID = :OBJID) AND (A.Hidden = 'N')
UNION
SELECT A.ID, A.Place1_ID As OtherPlace_ID, P.NAME As Name    
  FROM MLBDistances A
  JOIN MLBPlaces P ON P.ID=A.Place1_ID
  WHERE (A.Place2_ID = :OBJID) AND (A.Hidden = 'N')
ORDER BY 3 COLLATE PXW_CSY

Generated by ABRA Software a.s. 27.10.2021 16:35:26