1

Topic: The help with request

Children help with request and communication of two tables.
[img=https://c.radikal.ru/c21/1808/85/bc070da6bcbe.png]
[img=https://c.radikal.ru/c15/1808/58/4226331df697.png]
There are two tables, Table1 and Table2, arrival and the expenditure. Each record has number, the name and record date. It is necessary for me that in other table or , in single line under number and date the arrival and expenditure total was deduced. For example the arrival and expenditure total under number 10 and date for August, 3rd. If there are records for August, 4th, there is a new line with summation. Numbers can change, . 10 it not constant value.
Whether prompt it is possible to make such sampling, if yes that as?
Example on a screenshot:
[img=https://b.radikal.ru/b02/1808/09/05977cfbd901.png]

2

Re: The help with request

mbs92;

SELECT A.ID, A. [DATE], SUM (A.PRIHOD) AS SUMM_PRIHOD
FROM TABLE1 AS A
GROUP BY A.ID, A. [DATE]

3

Re: The help with request

For the second table also as wrote above.
Then results of FullDzhojnite
Deduce those values which are necessary to you
The only thing that - I still dateins to date would transform

4

Re: The help with request

And why sampling id instead of numbers?

SELECT A.ID, A. [DATE], SUM (A.PRIHOD) AS SUMM_PRIHOD
FROM TABLE1 AS A
GROUP BY A.ID, A. [DATE]

5

Re: The help with request

mbs92;
Well let will be under number

SELECT A.nomer, A. [DATE], SUM (A.PRIHOD) AS SUMM_PRIHOD
FROM TABLE1 AS A
GROUP BY A.nomer, A. [DATE]

6

Re: The help with request

Thanks for the help, turned out!