Access. Sql Inner join. 2 2015+ 2015
|
|
, 10 2016 . 20:13
+
2
1 12 . 2015
SELECT Center AS Nam2, -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=1)) AS Jun, -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=2))+Jun AS , -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=3))+ AS , -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=4))+ AS , -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=5))+ AS , -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=6))+ AS , -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=7))+ AS , -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=8))+ AS , -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=9))+ AS , -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=10))+ AS , -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=11))+ AS , -SUM(qdfPayments.IncomePaymentSumCalc*(Month(PaymentDate)=12))+ AS
FROM qdfPayments
WHERE Year(qdfPayments.PaymentDate)=2015 And Center<>''
GROUP BY Center;
() <2015
SELECT qdfPayments.Center AS Nam, Sum(qdfPayments.IncomePaymentSumCalc) AS Kum
FROM qdfPayments
WHERE (((Year(qdfPayments.PaymentDate))<2015))
GROUP BY qdfPayments.Center;
JOIN . 2015 + 2015
2015 12 000 . 2015 1 000 .
---------- 2015
----13000
??
http://www.sql.ru/forum/1199956/access-sql-inner-join-obedinit-2-tablicy-summirovat-itog-do-2015-yanvar-za-2015
