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