SQL - SQL Server, consultas n a n

mysql> SELECT * FROM tabla;

+------+-------------+

| id   | descripcion |

+------+-------------+

|    1 | uno         |

|    1 | one         |

|    1 | un          |

|    2 | dos         |

|    2 | two         |

|    2 | deux        |

|    3 | tres        |

|    3 | three       |

|    3 | trois       |

+------+-------------+

9 rows in set (0.00 sec)

mysql> SELECT

    ->   id,

    ->   GROUP_CONCAT(descripcion) numeros

    -> FROM

    ->   tabla

    -> GROUP BY

    ->   id;

+------+------------------+

| id   | numeros          |

+------+------------------+

|    1 | uno,one,un       |

|    2 | dos,two,deux     |

|    3 | tres,three,trois |

+------+------------------+

3 rows in set (0.00 sec)

SELECT s.* -- O los datos que quieras de saben

FROM cie c

inner join tablaIntermedia ti on c.idCie = ti.idCie

inner join saben s on ti.idsaben = s.idsaben

WHERE idCie = @idCie -- la variable que seleccionara el usuario