-

   rss_sql_ru_access_programming

 - e-mail

 

 -

 LiveInternet.ru:
: 16.03.2006
:
:
: 4

:


, 10 2015 . 20:28 +
. , , . 2 ( -). , buildings.shed_secondary OBJ_APP_quantity, Vadims_sort_number = 9,10,11...61.
Vadims_sort_number = 24 .
 
SELECT  buildings.shed_secondary,   buildings.GF , buildings.shed_primary, buildings.queue,
SUM(IIf(apparature.Vadims_sort_numb=24,OBJ_APP.quantity,0)) AS Sum24
FROM apparature INNER JOIN (buildings INNER JOIN OBJ_APP ON buildings.ID_OBJ = OBJ_APP.ID_OBJ) ON apparature.ID_APP = OBJ_APP.ID_APP
GROUP BY buildings.shed_secondary, buildings.GF, buildings.shed_primary, buildings.queue


sum(IIf(apparature.Vadims_sort_numb=19,OBJ_APP.quantity,0)) AS Sum19,
sum(IIf(apparature.Vadims_sort_numb=20,OBJ_APP.quantity,0)) AS Sum20,
sum(IIf(apparature.Vadims_sort_numb=21,OBJ_APP.quantity,0)) AS Sum21,
sum(IIf(apparature.Vadims_sort_numb=22,OBJ_APP.quantity,0)) AS Sum22,
. 60. , - ?

http://www.sql.ru/forum/1136407/kak-sozdat-cikl-summ-v-zaprose


: [1] []
 

:
: 

: ( )

:

  URL