Re: [sqlite] Multiple inner join confusion

Thanks to Richard for responding—I will do as he suggests. I am still curious about the cause of the error, though. After sleeping on it my hypothesis is that the temporary table generated by the first of my inner joins has columns with names "aa.i" and "aa.j", so the using clause of the

RE: [sqlite] Multiple inner join confusion

] Subject: Re: [sqlite] Multiple inner join confusion 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 co

Re: [sqlite] Multiple inner join confusion

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

[sqlite] Multiple inner join confusion

I'm a novice SQL user, and I'm confused by an apparently arbitrary limitation on multiple inner joins. I'm able to use the "using" clause for the first join but not for the second. I assume that I'm doing something silly out of ignorance. Any explanation for this behavior will be greatly