I have SQL Query which I need to conver to 4GL. I am strugling with two issues. First, the query behave in a strange way, second, conversion.
The Query
select RD.ponum, V.VendorNum, AH.invoicedate, AH.invoiceamt, AH.entryperson
from pub.rcvhead RH
inner join pub.rcvdtl RD on...