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
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
