Consulta con left join

[Libras]

Otra Opcion con un full outer join :)

Código SQL:

CREATE TABLE #temp
(
descripcion VARCHAR(100),
cod_doc VARCHAR(20)
)
 
CREATE TABLE #temp2
(
cod_soc VARCHAR(20),
cod_doc VARCHAR(20)
)
 
 
INSERT INTO #temp VALUES ('ACTA DE NACIMIENTO','010')
INSERT INTO #temp VALUES ('CARTA DE NATURALIZACIÓN','020')
INSERT INTO #temp VALUES ('IDENTIFICACIÓN OFICIAL','030')
INSERT INTO #temp VALUES ('COMPROBANTE DE DOMICILIO','040')
INSERT INTO #temp VALUES ('CURP','050')
INSERT INTO #temp VALUES ('ACTA DE MATRIMONIO','060')
INSERT INTO #temp VALUES ('CONTRATO DE AHORRO','070')
INSERT INTO #temp VALUES ('ESCRITURA CONSTITUTIVA','110')
INSERT INTO #temp VALUES ('CÉDULA DE IDENTIFIC. FISCAL','120')
INSERT INTO #temp VALUES ('INSCRIPCIÓN REGISTRO PUBLICO','130')
INSERT INTO #temp VALUES ('IDENT.OFICIAL REPRESENT.LEGAL','140')
INSERT INTO #temp VALUES ('ESTADOS FINANCIEROS','150') 
 
 
INSERT INTO #temp2 VALUES ('00000003','070')
INSERT INTO #temp2 VALUES ('00000004','070')
INSERT INTO #temp2 VALUES ('00000005','030')
INSERT INTO #temp2 VALUES ('00000005','040')
INSERT INTO #temp2 VALUES ('00000005','060')
INSERT INTO #temp2 VALUES ('00000005','070')
INSERT INTO #temp2 VALUES ('00000006','070')
INSERT INTO #temp2 VALUES ('00000011','070') 
 
 
SELECT t3.descripcion, t3.cod_doc,t3.cod_soc,CASE WHEN t4.cod_soc IS NULL THEN 'No' ELSE 'Si' END AS entregado FROM(
SELECT * FROM #temp AS t1, (SELECT DISTINCT cod_soc FROM #temp2) AS t2
) t3 
FULL OUTER JOIN #temp2 AS t4 ON (t4.cod_doc=t3.cod_doc AND t3.cod_soc=t4.cod_soc)
 

saludos!!