Código SQL:
Ver originalCREATE TABLE #temp(
id INT,
cargo VARCHAR(20)
)
INSERT INTO #temp VALUES (3,'Fontanero')
INSERT INTO #temp VALUES (3,'Camionero')
INSERT INTO #temp VALUES (4,'Informatico')
INSERT INTO #temp VALUES (5,'Fontanero')
INSERT INTO #temp VALUES (5,'Electricista')
SELECT id FROM #temp WHERE cargo IN ('camionero','fontanero')
GROUP BY id
HAVING COUNT(*)=2