جمع بيانات في التقرير عن طريق group

[format82]

قمت بعدة محاولات وتوصلت الي كود ولكنه يعطي رسالة خطا

كود :

ADOQuery2.SQL.Add('select name_emp,sum(daen) as sdaen,sum(mden) as smden from t_daenen where date_e between :p1 and :p2 and name_emp in (select name_emp,sum(daen) as sdaen1,sum(mden) as smden1 from t_daenen where date_e between :p3 and :p4 group by name_emp'+')'+'group by name_emp');

رسالة خطا

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS