Re: [sqlite] LEFT OUTER JOIN + INNER JOIN problem

[Mario Frasca]

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