>I would say this can be done with one select command with the use of MIN(), MAX(). However, I am not sure if this would always be adequate:
>
>

>SELECT MIN(Invoice.ApprovedPersonName) AS FirstOne,MAX(Invoice.ApprovedPersonName) AS LastOne
> FROM Invoice WHERE Invoice.NoClient=Client.Numero ORDER BY Invoice.AddDate
>

>

And as Antonio pointed out, the FROM (or JOIN) needs to reference the Client table.

Unless what you're writing here is intended to be a correlated subquery, where the reference to Client is an outer reference....but again, if you can clarify what you're trying to do, that would probably help.