[mol]

كود :

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

---

هذا تعديل للاستعلام الاول في سطر OleDbDataAdapter da