>From what I sense, you want to have the fist and latest person that approved any invoice for every client? Correct?
>
>I think it can be done very simple:
>
>

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

I like that one as well.

Thanks