Извините по поводу ExistsJoin - начал читать с конца
Если не критично использование двух запросов, то можно сделать так
PHP код:
CustConfirmJour custConfirmJour, custConfirmJour1;
CustConfirmJour custCJ;
;
while select SalesId, maxof(confirmdocnum)
from custConfirmJour1 group by SalesId
join salesid
from custCJ group by SalesId
where custConfirmJour1.SalesId == custCJ.SalesId &&
custConfirmJour1.confirmdocnum == custCJ.confirmdocnum
{
select salesId, recid, confirmdocnum from custConfirmJour
where custConfirmJour.SalesId == custConfirmJour1.SalesId &&
custConfirmJour.confirmdocnum == custConfirmJour1.confirmdocnum;
print(custConfirmJour.SalesId +
' ' + int2str(custConfirmJour.recid) + ' ' + custConfirmJour.confirmdocnum);
}