>>Table InvoiceDetail has not single field primary key?
>
>It is InvoiceDetail.Numero.
SELECT AA.InvoiceDetailNumero, AB.InvoiceDetailNumero
FROM (SELECT MAX(InvoiceDetail.Numero) AS InvoiceDetailNumero
FROM Invoice INNER JOIN InvoiceDetail ON Invoice.Numero=InvoiceDetail.NoInvoice
WHERE Invoice.NoCompany=32 AND InvoiceDetail.NoStatus=7
) AA CROSS APPLY (SELECT MAX(Numero) AS InvoiceDetailNumero
FROM InvoiceDetail
WHERE Numero<AA.InvoiceDetailNumero
) AB
INNER JOIN InvoiceDetail AC ON AC.Numero=AB.InvoiceDetailNumero AND AC.NoStatus=3
