SELECT SUM(d.op_summa)AS opl, SUM(c.pu_sunna)as usl, a.get_karta,
   a.get_dzap,a.get_ztim1,a.get_dock,a.get_klient

FROM GET1 a

Left Join op_uslug d ON  a.get_karta = d.op_karta and a.get_dog = d.op_dogovor
left Join p_uslug c ON a.get_karta = c.pu_karta and a.get_dog = c.pu_dogovor


group by d.op_summa, c.pu_sunna,a.get_karta, a.get_dog,
         a.get_dzap,a.get_ztim1,a.get_dock,a.get_klient
order by a.get_karta

[SRC sql]SELECT
   a.get_id, d.dog_karta, a.get_dzap,a.get_ztim1,a.get_dock,a.get_klient

FROM
     GET1 a

Left Join DOGPAC d on d.dog_karta=a.get_karta

CREATE GENERATOR GEN_GET_ID;

CREATE TABLE GET1 (
    GET_ID      INTEGER NOT NULL,
    GET_KLIN    VARCHAR(150),
    GET_DZAP    DATE,
    GET_ZTIM1   VARCHAR(100),
    GET_ZTIM2   TIME,
    GET_DOCK    VARCHAR(200),
    GET_SPEC    VARCHAR(100),
    GET_KLIENT  VARCHAR(200),
    GET_KARTA   VARCHAR(80),
    GET_PR      VARCHAR(10),
    GET_ROGD    VARCHAR(100),
    GET_USLUG   VARCHAR(100),
    GET_AKT     INTEGER,
    GET_DOG     VARCHAR(155),
    GET_SUMM    NUMERIC(5,2),
    GET_NPR     VARCHAR(10),
    GET_REMARK  VARCHAR(255)
);

CREATE GENERATOR GEN_DOGPAC_ID;

CREATE TABLE DOGPAC (
    DOG_ID       INTEGER NOT NULL,
    DOG_KARTA    VARCHAR(100),
    DOG_FIO      VARCHAR(155),
    DOG_NOMER    VARCHAR(155),
    DOG_SUM      NUMERIC(5,2),
    DOG_SPECIAL  VARCHAR(100),
    DOG_DOC      VARCHAR(100),
    DOG_AVANS    NUMERIC(5,2),
    DOG_DATA     DATE
);

CREATE TABLE OP_USLUG (
    OP_ID       INTEGER NOT NULL,
    OP_FIO      VARCHAR(155),
    OP_USLUGA   VARCHAR(155),
    OP_VID      VARCHAR(255),
    OP_DATA     DATE,
    OP_SUMMA    NUMERIC(5,2),
    OP_KARTA    VARCHAR(155),
    OP_DOGOVOR  VARCHAR(255)
);

CREATE GENERATOR GEN_PU_ID;

CREATE TABLE P_USLUG (
    PU_ID       INTEGER NOT NULL,
    PU_FIO      VARCHAR(255),
    PU_USLUGA   VARCHAR(155),
    PU_SUNNA    NUMERIC(5,2),
    PU_ACTIV    INTEGER,
    PU_KARTA    VARCHAR(155),
    PU_DOGOVOR  VARCHAR(255),
    PU_KOL      INTEGER
);