F18

znači gleda se FAKT i provjerava se broj veze tj. polja FAKT->BRDOK i KALK->BRFAKTP, provjerava se sve gdje nema veze fakt->kalk

SELECT 
    fakt.idfirma, 
    fakt.idtipdok, 
    fakt.brdok, 
    fakt.idpartner, 
    fakt.datdok,
    ( SELECT ROUND( SUM( kolicina * cijena ), 2 ) FROM fmk.fakt_fakt WHERE idfirma = fakt.idfirma AND brdok = fakt.brdok AND idtipdok = fakt.idtipdok ) AS ukupno,
    array_to_string( array( SELECT trim(idroba) FROM fmk.fakt_fakt WHERE idfirma = fakt.idfirma AND brdok = fakt.brdok AND idtipdok = fakt.idtipdok ), ', ' ) AS roba

FROM fmk.fakt_fakt fakt 
LEFT JOIN fmk.roba roba ON fakt.idroba = roba.id
LEFT JOIN fmk.fakt_doks doks ON fakt.idfirma = doks.idfirma AND fakt.idtipdok = doks.idtipdok AND fakt.brdok = doks.brdok
WHERE rpad( fakt.brdok, 10 ) NOT IN ( SELECT rpad( brfaktp, 10 ) FROM fmk.kalk_kalk WHERE idvd = '14' AND datdok >= '2012-01-01' AND datdok <= '2013-12-31' GROUP BY brfaktp )
      AND roba.tip <> 'U' AND roba.id NOT IN ('OZ','IT','SP-9') AND roba.id NOT LIKE 'F18%' 
      AND doks.datdok >= '2012-01-01' AND doks.datdok <= '2013-12-31'
      AND doks.idtipdok IN ('10', '11')
      AND ( SELECT COUNT(*) FROM fmk.kalk_kalk WHERE idroba = fakt.idroba ) > 0
GROUP BY fakt.idfirma, fakt.idtipdok, fakt.brdok, fakt.idpartner, fakt.datdok
ORDER BY fakt.idfirma, fakt.datdok, fakt.idtipdok, fakt.brdok