я так достаю:
Код:
select
VENDTABLE.ACCOUNTNUM
,VENDTABLE.NAME
,ADDRESS.ZIPCODE
,ADDRESS.PHONE
,ADDRESS.PHONELOCAL
from VENDTABLE VENDTABLE
inner join DIRPARTYADDRESSRELATIONSHIP DIRPARTYADDRESSRELATIONSHIP
on DIRPARTYADDRESSRELATIONSHIP.PARTYID = VENDTABLE.PARTYID
inner join DIRPARTYADDRESSRELATIONSHI1066 DIRPARTYADDRESSRELATIONSHI1066
on DIRPARTYADDRESSRELATIONSHI1066.PARTYADDRESSRELATIONSHIPRECID = DIRPARTYADDRESSRELATIONSHIP.RECID
and DIRPARTYADDRESSRELATIONSHI1066.REFCOMPANYID = 'DAT'
inner join ADDRESS ADDRESS
on ADDRESS.RECID = DIRPARTYADDRESSRELATIONSHI1066.ADDRESSRECID
and ADDRESS.DATAAREAID = DIRPARTYADDRESSRELATIONSHI1066.REFCOMPANYID
where VENDTABLE.DATAAREAID = 'DAT'