Objektová akce

Kód:

3

Tělo:

Select '04', LeftSide_ID from Relations where REL_DEF = 1015 AND RightSide_ID = :OBJID 
  union Select '06', LeftSide_ID from Relations where REL_DEF = 1016 AND RightSide_ID = :OBJID
    union Select '02', LeftSide_ID from Relations where REL_DEF = 1017 AND RightSide_ID = :OBJID
      union Select '12', LeftSide_ID from Relations where Rel_def = 1018 AND RightSide_ID = :OBJID 
        union Select '64', LeftSide_ID from Relations where Rel_def = 1022 AND RightSide_ID = :OBJID
union all

SELECT 'JO', a.JobOrder_ID
   FROM PLMCooperations A
   WHERE a.ID = :OBJID        

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