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