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

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

select KATSOPR.NSOPR,katsopr.dsopr,
katorg.name,
katmc.name,katmc.barkod, if (GROUPMC.kod=4302,'1','2'),spsopr.price,spsopr.KOLFACT,spsopr.price*spsopr.KOLFACT
 from   KATSOPR,katnazna ,shipment,ttndoc,spsopr,katmc,katorg,GROUPMC
where (( '201' == katsopr.vidsopr
    and '1109' == ttndoc.wtable
    and katsopr.nrec == ttndoc.cdoc
    and ttndoc.cshipment == shipment.nrec
    and katsopr.cnazna == katnazna.nrec
    and katsopr.nrec ==spsopr.csopr
    and katsopr.corg ==katorg.nrec
    and spsopr.CMCUSL ==katmc.nrec
    and katmc.CGROUPMC ==GROUPMC.nrec))
    and upcase(katnazna.name)= upcase(shipment.name)
    and spsopr.KOLFACT=0.5
    and spsopr.price=2203.40;