SQL Statement - Query A List Of Values

Hello
 I have a newbie question.
 If I have a table of the form:



Table1{id, name} with the values

id: 9 , name: test1,
id: 7 , name: test2,
id: 3 , name: test3,
id: 15 , name: test4,
id: 5 , name: test5,
id: 13 , name: test6,
......
...

If I have a list generated from user selection ( LIST{1, 7, 8, 15} ,) will I in a way be able to use this list in a query of the form, thus only having to make one query to the database:
SELECT id, name
FROM Table1
WHERE Table1.id in LIST

 Or is the solution to make multiple queries to the database, one for each member of the list, of the form:

SELECT id, name
FROM Table1
WHERE ID = @ID

Thanks in advance
 /dresen