🚀 go-pugleaf

I have table FIOPEDOC with these records :

OPE    DOC_1    DOC_2
001              FTS     (DOC_1 = ''   it is not null)
058              FTA
071    CGE       CGA
071    FTA       CGA

I have this view :

CREATE VIEW OPE_DOC_VIEW_CPY(
    CODOPE,  TIPDOC_1, TIPDOC_2, CODDOC_1, DES60)
AS
select a.codope, a.doc_1 , a.doc_2 , b1.coddoc, a1.des60
from fiopedoc a
left join fitipdoc a1 on (a.doc_1 = a1.coddoc)
      join coddoc   b1 on (a.doc_1 = b1.tipdoc );

I get record only for OPE = 071 and miss those which has DOC_1 = '' :

CODOPE TIPDOC_1 TIPDOC_2 CODDOC_1   DES60
071     CGE      CGA       CGE      jkhkj
071     FTA      CGA       FAA      jkjkl
071     FTA      CGA       FTA      hjkhkj    ...

With Left Join I expect to receive all records from table FIOPEDOC , 
completed with data retrieved from joined table like :

CODOPE TIPDOC_1 TIPDOC_2 CODDOC_1
001              FTS
058              FTA
071     CGE      CGA       CGE
071     FTA      CGA       FAA
071     FTA      CGA       FTA ...

why I miss first 2 records ?

Adalberto Baldini