I want to SUM(COLUMN) on different columns of different table at the same time- in a single query in MsAcces.And there is a single condition which every table should meet.I tried the following way-
SELECT
SUM(SalesInvoice.`TotalAmount`)AS SalesInvoice_TotalAmount,
SUM(SalesInvoice.`Paid`)AS SalesInvoice_Paid,
SUM(SalesInvoice.`Due`)AS SalesInvoice_Due,
SUM(PurInvoice.`TotalAmount`)AS PurInvoice_TotalAmount,
SUM(PurInvoice.`Paid`)AS PurInvoice_Paid,
SUM(PurInvoice.`Due`)AS PurInvoice_Due,
SUM(EmpPayment.`Payment`)AS EmpPayment_Payment,
SUM(Cost.`Amount`)AS Cost_Amount,
SUM(OutSideIncome.`Amount`)AS OutSideIncome_Amount,
SUM(BankTransaction.`DipositAmount`)AS BankTransaction_DipositAmount,
SUM(BankTransaction.`WithdrawnAmount`)AS BankTransaction_WithdrawnAmount,
SUM(BankTransaction.`Balance`)AS BankTransaction_Balance
FROM
`SalesInvoice` SalesInvoice,
`PurInvoice` PurInvoice,
`EmpPayment` EmpPayment,
`Cost` Cost,
`OutSideIncome` OutSideIncome,
`BankTransaction` BankTransaction

WHERE SalesInvoice.SalesDate BETWEEN #1/1/2008# AND #6/30/2008#
AND PurInvoice.PurchaseDate BETWEEN #1/1/2008# AND #6/30/2008#
AND EmpPayment.Paymentdate BETWEEN #1/1/2008# AND #6/30/2008#
AND Cost.Date BETWEEN #1/1/2008# AND #6/30/2008#
AND OutSideIncome.Date BETWEEN #1/1/2008# AND #6/30/2008#
AND BankTransaction.Date BETWEEN #1/1/2008# AND #6/30/2008#
But it is not generating the accurate result.Is there any problem? PLS help.