Třídová akce

Kód:

1

Tělo:

SELECT A.OwnerType, A.Owner_ID, A.SubType, FO.Parent_ID FROM SYS$CCPhoneNumbers A
  LEFT JOIN FirmOffices FO on (FO.ID=A.Owner_ID and A.OwnerType=2)
  WHERE A.Text = :Area||:PhoneNumber
UNION
SELECT A.OwnerType, A.Owner_ID, A.SubType, FO.Parent_ID FROM SYS$CCPhoneNumbers A
  LEFT JOIN FirmOffices FO on (FO.ID=A.Owner_ID and A.OwnerType=2)
  WHERE A.Text = '00'||:Area||:PhoneNumber
UNION
SELECT A.OwnerType, A.Owner_ID, A.SubType, FO.Parent_ID FROM SYS$CCPhoneNumbers A
  LEFT JOIN FirmOffices FO on (FO.ID=A.Owner_ID and A.OwnerType=2)
  WHERE A.Text = :PhoneNumber

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