How to print the name of many ID query SQL

Question

I have 2 queries one is this:

select nameCode
from users
where id = 3

When this query is executed there are many nameCode like

9616,1234,2456,3678...etc

Now I have this other query:

select description
from rights
where nameCode = 1234

and when I execute it, it shows

1234 => "Rights to use car"

How can I make a query where it takes all the nameCode and shows me all the description?

Thank you in advance.