05.08.2015, 10:04 | #7 |
Участник
|
я так достаю:
Код: 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' Последний раз редактировалось AnGor; 05.08.2015 в 10:06. |
|
|
|