[amonem]

(29-12-20, 07:52 PM)mol كتب :

كود :

SqlDataAdapter da = new SqlDataAdapter(@"SELECT ID, SUM(total) AS total FROM (SELECT ID, SUM(Numpr_Total) AS total FROM Table_2 GROUP BY ID UNION ALL SELECT ID, SUM(AS_Total) AS total FROM Table_3 GROUP BY ID) AS T GROUP BY ID", cnn);

تمام الكود دا اشتغل والنتيجه 100% بس تقيل فى التنفيذ بياخد وقت طويل حوالى 3 دقائق