select
O.TO_ID,
O.TO_DELIVER,
O.TO_DATE,
O.TO_DELIVERY,
O.TO_DISCOUNT,
O.TO_VARIANT,
O.TO_COMMENT,
O.TO_CLIENT,
O.TO_WEIGHT,
C.TC_NAME,

sum(OP.TOP_QUANTITY) as VES1,
sum(OP.TOP_QUANTITY * G.TG_PRICEOUT * ( 1  + G.TG_NDS /  100 )) as SUMMA1

from
TAB_ORDER O left join TAB_CLIENTS C on O.TO_CLIENT = C.TC_ID
            left join
            TAB_ORDERPOSITIONS OP on O.TO_ID = OP.TOP_ORDER
            left join TAB_GOODS G on G.TG_ID = OP.TOP_GOOD


group by
O.TO_ID,
O.TO_DELIVER,
O.TO_DATE,
O.TO_DELIVERY,
O.TO_DISCOUNT,
O.TO_VARIANT,
O.TO_COMMENT,
O.TO_CLIENT,
C.TC_NAME,
O.TO_WEIGHT

having
(TO_DATE between '20.04.03' and '20.04.03') and (O.TO_DELIVER =  0 )