SQL: How to fetch data with missing field values?

Question

SQL

There are two tables: users(fields: id, login, password, email) and users_online(fields: id_user, last_time).
I make a selection according to the following SQL query:

SELECT * 
FROM users, users_online
WHERE (
users.id = users_online.id_user
)

As a result, it gives me records of only those id that are in both tables.
I need to make a selection that will display all records from the users table and if there are records in the users_online table for a certain id, then supplement the first table with these values, if there are none, leave the field values ​​empty accordingly.
How should it be done? What SQL query should I write?

Answer 1

SELECT * FROM users LEFT JOIN users_online ON(users.id = users_online.id_user);