Re: [sqlite] Multiple inner join confusion

2004-04-12 Thread Rob Duncan
lar selects? select * from aa inner join bb on (aa.i=bb.i); aa.i aa.j bb.i -- 1 2 1 5 6 5 select * from aa inner join bb using (i); aa.i aa.j 1 2 5 6 Thanks, Rob. On Apr 12, 2004, at 5:00 AM, D. R

[sqlite] Multiple inner join confusion

2004-04-11 Thread Rob Duncan
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