while select salesTable where salesTable.SalesStatus == SalesStatus::Invoiced join count(recId) from custInvoiceJour group by SalesId where custInvoiceJour.SalesId == salesTable.SalesId {