.


:




:

































 

 

 

 





, , , , , , , . :

(1 );

, (2 );

, , :

<=

. , ( ) , .

 

 

.

 

 

:

 

 

SQL :

SELECT ., .[ ], Sum([]*[]*(1+[]-[])) AS

FROM INNER JOIN ( INNER JOIN ON .[ ] = .[ ]) ON .[ ] = .[ ]

GROUP BY ., .[ ];

 

 

:

 

SQL :

SELECT .[ ], Sum(.[ ]) AS [Sum- ]

FROM

GROUP BY .[ ];

, 6 7 . .

, , :

 

 

: [ ]![] - Nz([ ]![Sum- ])

Nz , Null Sum- 0, Access Null . .

 

 

. , , . . SQL :

SELECT [ ]., [ ].[ ], [ ]., [ ].[Sum- ], [ ]!-Nz([ ]![Sum- ]) AS

FROM [ ] LEFT JOIN [ ] ON [ ].[ ] = [ ].[ ];

 

. QBE SQL .





:


: 2016-11-12; !; : 381 |


:

:

! . .
==> ...

1012 - | 844 -


© 2015-2024 lektsii.org - -

: 0.012 .