Re: [sqlite] JOIN works very strange [3.6.2]

On Sat, Sep 20, 2008 at 08:45:16AM +0400, Alexander Batyrshin scratched on the wall: > 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 >

Re: [sqlite] JOIN works very strange [3.6.2]

I just want to add that this SQL query works great at 3.5.4. And this is explain: addr opcode p1p2p3p4 p5 comment - - -- - 0 Trace 0 0 0 EXPLAIN SELECT town.id, tow