Encontrar campos que coinciden en dos tablas

[Libras]

Código SQL:

CREATE TABLE #temp
(
nombre VARCHAR(200)
)
 
CREATE TABLE #temp1
(
nombreb VARCHAR(200)
)
 
INSERT INTO #temp VALUES('computex S.A')
INSERT INTO #temp VALUES('citycomp')
INSERT INTO #temp VALUES('netland technology')
INSERT INTO #temp VALUES('voip service mexico')
INSERT INTO #temp VALUES('sinergy')
INSERT INTO #temp VALUES('netitlan corp')
 
INSERT INTO #temp1 VALUES('computex')
INSERT INTO #temp1 VALUES('citycomp')
INSERT INTO #temp1 VALUES('netland')
INSERT INTO #temp1 VALUES('voip service')
INSERT INTO #temp1 VALUES('sinergy')
INSERT INTO #temp1 VALUES('netitlan')
 
SELECT 
CASE
WHEN
charindex(nombreb,nombre,1)=1 THEN 'tabla 1' + nombre + '-' + 'tabla 2' + nombreb END AS campo 
FROM #temp AS t1, #temp1 AS t2
WHERE charindex(nombreb,nombre,1)=1
GROUP BY nombre,nombreb
 

Saludos!