В указанной теме был ответ:
(SELECT FIRST 1 P.PERSON_FIRSTNAME || COALESCE(' ' || P.PERSON_LASTNAME, '') FROM CONT
INNER JOIN ASO$PERSON P ON P.ID = CONT.ID
WHERE CONT.COMP_ID = :COMP_ID
AND CONT.IS_DEFAULT = 1) CONT_NAME
Общий вид SQL:
SELECT
ADDRESS_VIEW AS COMP_ADDRESS,
ADDRESS_STR, --улица
ADDRESS_HOME, -- номер дома
ADDRESS_CORPUS, --корпус
ADDRESS_FLAT, -- квартира, офис
ADDRESS_CITY, -- город
ADDRESS_INDEX, -- индекс
ADDRESS_BOX, -- а/я
REGION.NAME REGION_NAME, -- р-н
OBLAST.NAME OBLAST_NAME, -- область
COUNTRY.NAME COUNTRY_NAME, -- страна
(SELECT COALESCE(COMP.COMP_FULLNAME, COMP_BASE.NAME) FROM COMP
INNER JOIN ASO$BASE COMP_BASE ON COMP_BASE.ID = COMP.ID
WHERE COMP.ID = :COMP_ID)
AS COMP_FULLNAME -- Наименование компании
, <СЮДА ВСТАВИТЬ ПОДЗАПРОС ДЛЯ ФИО>
FROM COMP_ADDRESS
LEFT JOIN ASO$BASE REGION ON REGION.ID = COMP_ADDRESS.REGION_ID
LEFT JOIN ASO$BASE OBLAST ON OBLAST.ID = COMP_ADDRESS.OBLAST_ID
LEFT JOIN ASO$BASE COUNTRY ON COUNTRY.ID = COMP_ADDRESS.COUNTRY_ID
WHERE COMP_ADDRESS.ID = :COMP_ADDRESS_ID