Problem how to combine to two tables

Ok, to explain my problem, it is the easiest way, to make an example:

let's say we have two tables:

Table1 looks like this:

Employee_ID Room
------------------------
{1,3} 201
{3} 202

And Table2 looks like this:

ID Employee
---------------
1 Torsten
2 Markus
3 Daniel

This means, that if the two tables are linked properly, that Torsten and
Daniel sit in room no. 201 and Markus in room No. 202. And linking properly
is my problem:

I want an output like this

Employee_ID Room ID Employee
{1,3} 201 1 Torsten
{1,3} 201 3 Daniel
{2} 202 2 Markus

That means, that the SELECT-statement has to be something like this:
SELECT * from Table1,Table2 where Table1.Employee_ID=Table2.ID;

But of course this doesn't work, because I can't compare an int to a set of
int :-(

Does anyone know how to do this correct?