How to make a selection from three tables?

Question

PHP

How to make a selection from three tables linked by one table?
I write something like this but it doesn't work

SELECT game.id,npc.title,users.login FROM game INNER JOIN npc ON game.id = npc.npc_id AND game.type = 'npc' INNER JOIN users ON game.id = users.user_id AND game.type = 'user'

Here is an example of tables

Answer 1

SELECT game.id,npc.title,users.login 
FROM game 
LEFT JOIN npc ON game.id = npc.npc_id AND game.type = 'npc' 
LEFT JOIN users ON game.id = users.user_id AND game.type = 'user'
WHERE game.type IN('npc' , 'user')

Answer 2

если я правильно понял картинку, то вам нужно использовать UNION