Złączenie 3 tabel Opcje

[Kshyhoo]

Myślę i myślę i nie mogę skumać. Otóż:

[PHP] pobierz, plaintext 
users
id | name
--+-------------
 1 | Novak
 2 | Kovalski
 3 | Cebula
 
adventure
id | name
--+-------------
 1 | PO
 2 | PiS
 
drops (przechowywane ID i czas)
id | adv | user1 | user2 | user3 | datetime
---+-----+-------+-------+-------+-----------
 1 |  1  |   1   |   3   |   2   | 1473542311
 2 |  2  |   2   |   3   |   1   | 1473600401
[PHP] pobierz, plaintext 

Chciałbym osiągnąć:

[PHP] pobierz, plaintext 
id | adv |  user1   |  user2   |  user3   | datetime
---+-----+----------+----------+----------+-------------
 1 |  PO | Novak    | Cebula   | Kovalski | 1473542311
 2 | PiS | Kovalski | Cebula   | Novak    | 1473600401
[PHP] pobierz, plaintext 

Moje zapytanie znajduje ID a nie nazwy:

[SQL] pobierz, plaintext 
	SELECT
 d.id,
 d.adv,
 d.user1,
 d.user2,
 d.user3
FROM drops d
LEFT JOIN users u ON u.id=d.id
LEFT JOIN adventure a ON a.id=d.id
[SQL] pobierz, plaintext 

[sankalppatil732]

Here is a general SQL query syntax to join three or more table. This SQL query should work in all major relation database e.g. MySQL, Oracle,

SELECT t1.col, t3.col FROM table1 join table2 ON table1.primarykey = table2.foreignkey
join table3 ON table2.primarykey = table3.foreignkey