I have a select like this:

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=1

This gives 115063 records.

Now, I would like to collect some field from InvoiceDetail. So, I do something like this:

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=1

This gives 118419.

Basically, if I change the field to something else, it always gives a different number of records.

Obviously, something is missing here. Anyone would know how I can extract some fields for the records related to the COUNT(*)?