Уважаемые знатоки! в нижеприведённой команде
[code]Select smetarab->nrazd, Min(razdel->naimrazd) As naimrazd, Sum(Round(smetarab->osn_zarp*rccs->indzarp*kolvo,cop)) As sum_osn_zarp, Sum(Round(smetarab->expl_mech*rccs->indmech*kolvo,cop)) As sum_mech, Sum(Round(smetarab->zarp_mech*rccs->indzarp*kolvo,cop)) As sum_zarp_mech, [color=Red]Sum(Round(smetarab->mtrls*rccs->indmtrls*kolvo,cop)) As sum_mtrls[/color],;
sum(Round(smetarab->trud_OSN*kolvo*(1+razdel->procnachis/100),2)+Round(smetarab->trud_MEH*kolvo*(1+razdel->procnachis/100),2)) As sum_trud,;
sum(Round(smetarab->trud_OSN*kolvo*(1+razdel->procnachis/100),2)) As sum_trud_osn,;
sum(Round(smetarab->trud_MEH*kolvo*(1+razdel->procnachis/100),2)) As sum_trud_meh,;
sum(Round(smetarab->osn_zarp*rccs->indzarp*kolvo,cop)+Round(smetarab->expl_mech*rccs->indmech*kolvo,cop)+Round(smetarab->mtrls*rccs->indmtrls*kolvo,cop)) As sum_prz,;
sum(Round(gesnnaim->procnakl/100*Round(smetarab->osn_zarp*rccs->indzarp*kolvo,cop)+Round(smetarab->zarp_mech*rccs->indzarp*kolvo,cop),cop)) As sum_nakl,;
MIN(smetarab->procnakl) As procnakl,;
sum(Round(razdel->procsmpr/100*Round(smetarab->osn_zarp*rccs->indzarp*kolvo,cop)+Round(smetarab->zarp_mech*rccs->indzarp*kolvo,cop),cop)) As sum_smpr,;
MIN(smetarab->procsmpr) As procsmpr,;
sum(Round(razdel->procwrem/100*(Round(smetarab->osn_zarp*rccs->indzarp*kolvo,cop)+Round(smetarab->expl_mech*rccs->indmech*kolvo,cop)+Round(smetarab->mtrls*rccs->indmtrls*kolvo,cop)+Round(nr*kolvo,cop)+Round(smpr*kolvo,cop)),cop)) As sum_wrem,;
sum(Round(razdel->proczim/100*(Round(smetarab->osn_zarp*rccs->indzarp*kolvo,cop)+Round(smetarab->expl_mech*rccs->indmech*kolvo,cop)+Round(smetarab->mtrls*rccs->indmtrls*kolvo,cop)+Round(nr*kolvo,cop)+Round(smpr*kolvo,cop)+Round(wrem*kolvo,cop)),cop)) As sum_zim,;
sum(Round(razdel->procproch/100*(Round(smetarab->osn_zarp*rccs->indzarp*kolvo,cop)+Round(smetarab->expl_mech*rccs->indmech*kolvo,cop)+Round(smetarab->mtrls*rccs->indmtrls*kolvo,cop)+Round(nr*kolvo,cop)+Round(smpr*kolvo,cop)+Round(wrem*kolvo,cop)+Round(zim*kolvo,cop)),cop)) As sum_proch,;
sum(Round(razdel->procnepr/100*(Round(smetarab->osn_zarp*rccs->indzarp*kolvo,cop)+Round(smetarab->expl_mech*rccs->indmech*kolvo,cop)+Round(smetarab->mtrls*rccs->indmtrls*kolvo,cop)+Round(nr*kolvo,cop)+Round(smpr*kolvo,cop)+Round(wrem*kolvo,cop)+Round(zim*kolvo,cop)+Round(proch*kolvo,cop)),cop)) As sum_nepr;
from smetarab, razdel, rccs, gesnnaim Into Cursor qurazd Where smetarab->nrazd=razdel->nrazd And smetarab->shifr=gesnnaim->shifr [color=Red]AND smetarab->index!=1[/color] Group By smetarab->nrazd Order By smetarab->nrazd[/code]
добавляю условие в Where не включать в суммирование строки, где поле smetarab->index=1(выделено красным). Но оно не работает, строки всё равно включаются в суммирование. В чём моя ошибка?