Código SQL [-]Select T1.CLAVE, T2.SUBCLAVE from TABLA1 T1 left join (Select CLAVE, SUBCLAVE from TABLA2 union Select CLAVE, 0 as SUBCLAVE from (Select CLAVE, from TABLA2 group by CLAVE)) T2 on T1.CLAVE = T2.CLAVE
Select T1.CLAVE, T2.SUBCLAVE from TABLA1 T1 left join (Select CLAVE, SUBCLAVE from TABLA2 union Select CLAVE, 0 as SUBCLAVE from (Select CLAVE, from TABLA2 group by CLAVE)) T2 on T1.CLAVE = T2.CLAVE