Галактика в вопросах и ответах

Код: Выделить всё

select
*,
(SpSopr.KOLFACT*SpSopr.Price) (FieldName = Stoim),
(SpSopr.SUMNDS+SpSopr.KOLFACT*SpSopr.Price) (FieldName = StoimNds)
from
   fpco (readonly),
   exclassval exclassvalRes,
   exclassseg exclasssegRes,
   exclassval exclassvalSt,
   exclassseg exclasssegSt,
   Pick,akt,SoprOrdB
where
((
     Katsopr.nrec     == SpSopr.cSopr
and  bdate           <<= KatSopr.dsopr   (noindex)   //фильтра на даты
and  edate           >>= KatSopr.dsopr   (noindex) 
and  word(111)        == KatSopr.vidSopr            //акты на прием услуг - снабжение
and  KatSopr.nrec     == SpSopr.cSopr
and  SpSopr.cMcUsl    == KatUsl.nrec
and  KatSopr.cOrg     == KatOrg.nrec                //контрагент
and  KatSopr.cDogovor == Dogovor.nrec               //договор
and  KatSopr.cOtvPodr == fpco.nrec                  //центр ответственности
and  Spsopr.nrec      == SoprOrdB.cSpSopr           //мвз
and  SoprOrdB.cPodr   == KatPodr.nrec

//----------код статьи---------------
      and SpSopr.nrec                  == exclassvalSt.crec
      and 1110                         == exclassvalSt.wtable
      and 217                          == exclassvalSt.classcode
      and exclassvalSt.cclassseg       == exclasssegSt.nrec

//----------код ресурса--------------
      and SpSopr.nrec                  == exclassvalRes.crec
      and 1110                         == exclassvalRes.wtable
      and 222                          == exclassvalRes.classcode
      and exclassvalRes.cclassseg      == exclasssegRes.nrec
))
  Condition on_MarkRes as SearchMarker(MarkRes, exclassvalRes.cclassseg ,IndexNo )
  Condition on_MarkOrg as SearchMarker(MarkOrg, KatSopr.cOrg ,IndexNo )
;