Re: [sqlite] Multiple inner join confusion

[D. Richard Hipp]

Rob Duncan wrote:
I'm a novice SQL user, and I'm confused by an apparently arbitrary 
limitation on multiple inner joins. 

select * from aa inner join bb using (i) inner join cc using (j);
SQL error: cannot join using column j - column not present in both tables
I suggest you work around the problem by coding the select like this:

   select * from aa, bb, cc where aa.i=bb.i and cc.j=aa.j;

--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]