=?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] -----------------------------------------------------------------------------