How to make a selection on 2 tables?

Question

MySQL

The database has a USERS table with id and name fields, and a USER_LOGINS table with user_id and login_time fields. Write a SQL query that will receive a selection with user_name, login_time fields for USER_LOGINS rows.
How to write a query correctly?
I figured out that I need to use the join operator, but I can’t think through the answer until it turns out like this:
SELECT users.Name AS user_name, user_logins.Login_time AS last_login
FROM users
LEFT OUTER JOIN
user_logins

Answer 1

I hope my short tutorial will help you deal with selections as well.

Answer 2

in join it is necessary to specify on what field to connect tables.
or so (if the name of the key field in the tables is the same)
select * from table1 join table2 using(id)

Answer 3

SELECT name, login_time FROM USERS u JOIN USER_LOGINS ul ON u.id=ul.user_id