Preview:
SELECT DirPartyTable.NAME ,CUSTTABLE.RECID ,  DirPartyTable.RECID ,CUSTTABLE.PARTY
FROM DirPartyTable
LEFT JOIN CUSTTABLE
ON DirPartyTable.RECID = CUSTTABLE.PARTY
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter