>>

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

>
>This SQL does not return any record.

I'm sorry, I have not your data.

MartinaJ