[ SQL/recordset ] Show NAME from other table instead of ID

I have one problem.

Some tables have only ID that refer from other table, and, in that table, exist what each numer means. When I create one table do display for example 10 itens of my main table, this table just show the ID instead of the NAME, or, will just who the fist NAME of all rows that that have revefenre on both tables.

So what i need Know is:

How to display NAME instead of ID, from one table that have for each ID, one NAME?

In my case, for example, I have the folowing table name and cel name:

CITY
id_city
nameofcity

1 - Rio de Janeiro

2 - São Paulo

3 - Belo Horizonte

4 - Curitiba

USER
id_user
city

1 - 1 : user 1 from city Rio de Janeiro

2 - 1 : user 2 from city Rio de Janeiro

3 - 2 : user 3 from city Rio de Janeiro ( error, must be São Paulo )

4 - 2 : user 4 from city Rio de Janeiro ( error, must be São Paulo )

5 - 4 : user 5 from city Rio de Janeiro ( error, must be Curitiba )

Really thanks for all that help me with this. Also, some link with tutorial or something useful will be really useful.