SELECT *, (SELECT TOP 1 ApprovedPersonName FROM Invoices WHERE NoClient = Client.Numero ORDER BY AddDate ) as firstperson, (SELECT TOP 1 ApprovedPersonName FROM Invoices WHERE NoClient = Client.Numero ORDER BY AddDate DESC) as Lastperson, FROM ClientWalter,
>SELECT TOP 1 Invoice.ApprovedPersonName FROM Invoice WHERE Invoice.NoClient=Client.Numero ORDER BY Invoice.AddDate >>
>SELECT TOP 1 Invoice.ApprovedPersonName FROM Invoice WHERE Invoice.NoClient=Client.Numero ORDER BY Invoice.AddDate DESC >>
>SELECT MIN(Invoice.ApprovedPersonName) AS FirstOne,MAX(Invoice.ApprovedPersonName) AS LastOne > FROM Invoice WHERE Invoice.NoClient=Client.Numero ORDER BY Invoice.AddDate >>