I have 2 tables: users, requests The table users contains: id, name, email....

The table requests contains: id, id_user, date.....

How can I use the column id_user to get the name of the user from the table users?

So I want to get the name with the id_user from table users.

CodePudding user response：

select requests.id_user ,
             users.name 
from users 
join requests on users.id = requests.id_user