Retrieving data with two tables

PHOTO EMBED

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

Saved by @almojahid #x++

CustTable custTable;
DirPartyTable dirPartyTable;

while  select  dirPartyTable order by Name
 join       custTable where  dirPartyTable.recID==custTable.Party
 {
      warning(custTable.AccountNum);
 }
content_copyCOPY