[sqlite] JOIN works very strange [3.6.2]

[Alexander Batyrshin]

 Hello everyone,

I gets strange result from this query on SQLite-3.6.2

SELECT
            town.id, town_log.new_player_id, player.name
FROM
            town_log
            LEFT JOIN town
            LEFT JOIN player
ON
            town.id = town_log.town_id AND town_log.new_player_id = player.id
WHERE
            town_log.id = 5195

As you can see this query should return only 1 row, because
town_log.id is unique key.
But I gets rows with different town.id (1 col), with constant
new_player.id (2 col) and JOIN do not work for player.name, couse 3
col is empty.

result:
[....]
45512       9266
44544       9266
45229       9266
46376       9266
45927       9266
46645       9266
[....]


Any ideas what's going on?

--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users