السلام عليكم و رحمة الله و بركاته
ما هو الخطأ هنا - برجاء المساعدة
SELECT suppliers.suppliers, "-" AS Account_Payable, add_doc.add_doc, Sum(Transaction.[grand total]) AS Depit, Sum (Transaction.[grand total]) AS Back, 0 AS credit,suppliers.home,suppliers.mobil, suppliers.job,suppliers.address,add_doc.mdate FROM suppliers INNER JOIN (add_doc INNER JOIN [Transaction] ON add_doc.add_doc = Transaction.add_doc) ON suppliers.suppliers = add_doc.supplier , (Sup_Back INNER JOIN [Transaction] ON Sup_Back.Sup_Back = Transaction.Sup_Doc) ON Suppliers.suppliers = Sup_Back.Supplier GROUP BY suppliers.suppliers, "-", add_doc.add_doc,sup_Back,suppliers.home,suppliers.mobil, suppliers.job,suppliers.address,add_doc.mdate UNION SELECT suppliers.suppliers, Account_Payable.Account_Payable, "-" AS add_doc, 0 AS depit, 0 As Back,Account_Payable.LE AS Creditsuppliers.home,suppliers.mobil, suppliers.job,suppliers,Account_Payable.Date FROM (suppliers INNER JOIN add_doc ON suppliers.suppliers = add_doc.supplier) INNER JOIN Account_Payable ON suppliers.suppliers = Account_Payable.[To Pay];

