استعلام توحيد بشرط

[M Badawy]

السلام عليكم و رحمة الله و بركاته

 

عندبي استعلام توحيد بس عاوز الاستعلام يفتح بشرط بيت تاريخين

 

 

 

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

 

 

 

أرجو المساعدة

[رمهان]

يمكن ذلك بوضع الشرط عند كل جملة select  وبالعبارة where .

ولكن كطريقة سهلة : اعمل استعلام جديد عادي وفي خانة اضافة الجداول في الاعلى ضع استعلام التوحيد المحفوظ واختر ماتريد من الاعمدة وتعريف الشروط المناسبة.

 

بالتوفيق