Gábor Farkas wrote:
i think it should only output the first row ( "5|admin|1|5|1|john" )
tried what you describe and get the answer you expect, not the one you got: sqlite> 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
(using ubuntu edgy, sqlite3 3.3.5)
using debian 3.1, sqlite3 3.3.8, the same also on Mac OS X, sqlite3 3.3.7... ciao, Mario ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------