[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);