> This is fixed in 3.3.6. 3.3.8 is current. A very basic question: What do these figure refer to? I can see the commandline SQLite utility, but no other .exe files. I am connecting in VB/VBA with a third-party dll. Do I have to do anything when there is an update in SQLite? Great software this SQLite!
RBS -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 14 November 2006 12:41 To: sqlite-users@sqlite.org Subject: Re: [sqlite] LEFT OUTER JOIN + INNER JOIN problem =?UTF-8?B?R8OhYm9yIEZhcmthcw==?= <[EMAIL PROTECTED]> wrote: > > select * from role > LEFT OUTER JOIN person_role on role.id = person_role.role_id > INNER JOIN person on person_role.person_id = person.id > WHERE person.id=1; > > 5|admin|1|5|1|john > 6|devel|||| > > i think it should only output the first row ( "5|admin|1|5|1|john" ) > so, am i doing something wrong here? > (using ubuntu edgy, sqlite3 3.3.5) > This is fixed in 3.3.6. 3.3.8 is current. http://www.sqlite.org/cvstrac/chngview?cn=3203 http://www.sqlite.org/cvstrac/tktview?tn=1830 -- D. Richard Hipp <[EMAIL PROTECTED]> ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------