I am also having difficulty getting to grips with the (awkward) join notation. In 3.0 how about support for Oracle type joins with (+) which seems far simpler to me :)
-----Original Message----- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: 12 April 2004 13:00 Cc: [EMAIL PROTECTED] 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 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]