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