Objektová akce

Kód:

3

Tělo:

Select DISTINCT '26', ShortFall_ID
FROM 
  POSMirrors
WHERE
 ShortFall_ID is NOT NULL
 AND ID = :OBJID

union

Select DISTINCT '26', XShortFall_ID
FROM 
  POSMirrors
WHERE
 XShortFall_ID is NOT NULL
 AND ID = :OBJID

union

Select DISTINCT '25', Overplus_ID
FROM 
  POSMirrors
WHERE
 Overplus_ID is NOT NULL
 AND ID = :OBJID

union

Select DISTINCT '25', XOverplus_ID
FROM 
  POSMirrors
WHERE
 XOverplus_ID is NOT NULL
 AND ID = :OBJID

union 
Select DISTINCT 'PM', OriginalMirror_ID
FROM 
  POSMirrors
WHERE
 OriginalMirror_ID is NOT NULL
 AND ID = :OBJID 
 
union 
SELECT DISTINCT 'PD', A.LeftSide_ID
FROM
  Relations A
WHERE
  (A.RightSide_ID = :OBJID) AND (Rel_Def = 1680)

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