why not use: SELECT A.ID <http://a.id/>, A.Column1, A.Column2, B.Column1, C.Column1 FROM A INNER JOIN B ON A.Column3 = B.ID <http://b.id/> INNER JOIN C ON B.Column2 = C.ID <http://c.id/>
? On Thu, Jul 2, 2009 at 2:53 PM, Ed Hawke < edward.ha...@hawkeyeinnovations.co.uk> wrote: > Hi all, > > I'm having problems getting nested inner joins to work with SQLite. As > far as I can tell from various resources the correct way of joining > multiple tables is this: > > SELECT A.ID, A.Column1, A.Column2, B.Column1, C.Column1 FROM A INNER > JOIN B (INNER JOIN C ON B.Column2 = C.ID) ON A.Column3 = B.ID > > However depending upon where I put the parentheses I get various > different errors from the viewer I use (SQLite Manager for Firefox). A > normal Inner Join without the nesting works fine. > > Can anyone tell me what I'm doing wrong? > > Regards, > > Ed > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- VerifEye Technologies Inc. 905-948-0015x245 7100 Warden Ave, Unit 3 Markham ON, L3R 8B5 Canada _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
