[amonem]

(29-12-20, 02:25 PM)mol كتب :

كود :

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

---

كود :

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

نفس رساله الخطا للاسف