SQL query to select results from two tables

Question

I has two tables on MS SQL Server. First with the cities, second with student names and city ID from first table, where this student lives.

I need a sql query that will return results like this:

Stella Paris

Bob Moscow,New York

Mary Paris,New York