Retrieving data with two tables

PHOTO EMBED

Sun Oct 24 2021 11:02:58 GMT+0000 (Coordinated Universal Time)

Saved by @almojahid #sqlquery 

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