[CDR]

стоило написать так:

select sum(SalesQty) from SalesLine
join count(recId) from SalesTable
where SalesTable.SalesId == SalesLine.SalesId
&& SalesTable.DeliveryDate <= today();

и заработало с inner join.