SELECT DirPartyTable.NAME ,CUSTTABLE.RECID ,  DirPartyTable.RECID ,CUSTTABLE.PARTY
FROM DirPartyTable
LEFT JOIN CUSTTABLE
ON DirPartyTable.RECID = CUSTTABLE.PARTY