Paste code

SELECT A.*,B.KEY_VALUE FROM DLAB_PROGRAMADATOSVPC.TMP_DBV_CREDITOS_MERCADO A LEFT JOIN E_DW_VIEWS.V_MST_ENCRIP_NRO_DOC_MDL_HISTDIA B ON A.NUM_DOC = CASE WHEN SUBSTR(NRO_DOC,1,2) = &#039;10&#039; AND LENGTH(NRO_DOC) = 11 THEN SUBSTR(NRO_DOC,3,8)  WHEN SUBSTR(NRO_DOC,1,2) = &#039;20&#039; AND LENGTH(NRO_DOC) = 11 THEN NRO_DOC ELSE &#039;X&#039; END