>Something like this?
>
>

>SELECT		Member.FirstName,
>		Member.LastName,
>		Details.AddDate,
>		Details.CountRecord
>FROM		Member
>Join		(
>			Select		Order.NoMember,
>					Max(Order.AddDate) as AddDate, 
>					Count(*) as CountRecord
>				FROM	Order
>				GROUP	BY Order.NoMember
>		) Details on Detais.NoMember = Member.Numero
>
>

This seems to work but the only difference is that I will not get the Member records having no orders.