SELECT COUNT(*) FROM (SELECT MAX(InvoiceDetail.Numero) AS InvoiceDetailNumero FROM Invoice INNER JOIN InvoiceDetail ON Invoice.Numero=InvoiceDetail.NoInvoice WHERE Invoice.NoCompany=32 GROUP BY InvoiceDetail.NoInvoice) Invoice2 INNER JOIN InvoiceDetail ON Invoice2.InvoiceDetailNumero=InvoiceDetail.Numero WHERE InvoiceDetail.NoStatus=7 AND InvoiceDetail.AddUser=1This gives 115063 records.
SELECT InvoiceDetail.NoInvoice FROM (SELECT MAX(InvoiceDetail.Numero) AS InvoiceDetailNumero FROM Invoice INNER JOIN InvoiceDetail ON Invoice.Numero=InvoiceDetail.NoInvoice WHERE Invoice.NoCompany=32 GROUP BY InvoiceDetail.NoInvoice) Invoice2 INNER JOIN InvoiceDetail ON Invoice2.InvoiceDetailNumero=InvoiceDetail.Numero WHERE InvoiceDetail.NoStatus=7 AND InvoiceDetail.AddUser=1This gives 118419.