>SELECT Member.FirstName,Member.LastName, > (SELECT MAX(Order.AddDate) FROM Order WHERE Order.NoMember=Member.Numero) AS AddDate, > (SELECT COUNT(*) FROM Order WHERE Order.NoMember=Member.Numero) AS CountRecord > FROM Member >>
select M.FirstName, M.LastName, O.AddDate, O.CountRecord from Member M inner join (select max(AddDate) as AddDate, count(*) as CountRecord, NoMember from [Order] group by NoMember) O on M.Numero = O.NoMember