SQL JOIN doesn't find guests, only users

Question

I am using this line of SQL code:

SELECT DISTINCT tb_online.ip, tb_users.id, tb_online.login, tb_online.page 
FROM tb_online
JOIN tb_users 
  ON tb_online.login=tb_users.username 
ORDER BY login ASC

The problem is that this line ON tb_online.login=tb_users.username means that SQL query only selects users but not guests (they don't have username in the tb_users table).

How could I make SQL query to select both users and guests?

Click on the [sql] tag, read the info. It includes guides like [this](https://stackoverflow.com/questions/17946221/sql-join-and-different-types-of-joins) — JohnHC, May 23 '17 at 08:08

score 1 · Answer 1 · answered May 23 '17 at 08:08

1

use left join:

SELECT DISTINCT tb_online.ip, tb_users.id, tb_online.login, tb_online.page 
FROM tb_online
LEFT JOIN tb_users 
  ON tb_online.login=tb_users.username 
ORDER BY login ASC

answered May 23 '17 at 08:08

Jens

67,715
15
98
113

Thank you very much – Lukas May 23 '17 at 08:10
@Lukas You are welcome – Jens May 23 '17 at 08:11

SQL JOIN doesn't find guests, only users

1 Answers1