السلام عليكم و رحمة الله و بركاته
عندبي استعلام توحيد بس عاوز الاستعلام يفتح بشرط بيت تاريخين
SELECT customers.customers, "-" AS Receipt_voucher, issue_doc.issue_doc,0 AS M, Sum(Transaction.[grand total]) AS Depit, 0 AS credit, customers.home, customers.mobil, customers.job, customers.address, issue_doc.mdate
FROM (customers INNER JOIN issue_doc ON customers.customers = issue_doc.customer) INNER JOIN [Transaction] ON issue_doc.issue_doc = Transaction.issue_doc
GROUP BY customers.customers, "-", issue_doc.issue_doc, customers.home, customers.mobil, customers.job, customers.address, issue_doc.mdate UNION SELECT customers.customers, "-" AS Receipt_voucher, issue_back.issue_back, Sum([grand total]) AS M, 0 AS depit, 0 AS Credit, customers.home, customers.mobil, customers.job, customers.address, issue_back.mdate
FROM (customers INNER JOIN issue_back ON customers.Customers = issue_back.Customer) INNER JOIN [Transaction] ON issue_back.issue_back = Transaction.issue_back
GROUP BY customers.customers, "-", issue_back.issue_back, customers.home, customers.mobil, customers.job, customers.address, issue_back.mdate UNION SELECT customers.customers, Receipt_voucher.Receipt_voucher, "-" AS issue_doc, 0 AS M, 0 AS depit, Receipt_voucher.LE AS Credit, customers.home, customers.mobil, customers.job, customers, Receipt_voucher.Date
FROM (customers INNER JOIN issue_doc ON customers.customers = issue_doc.customer) INNER JOIN Receipt_voucher ON customers.customers = Receipt_voucher.[Received from];
فى 3 تواريخ
receipt_Voucher
issue_doc
issue_Back
أرجو المساعدة