On 7/14/08, Ralf Jantschek <[EMAIL PROTECTED]> wrote: > Hello, > > > > I'm having problems with Inner Joins on m:n relations > > book <--> bookauthor <--> author > > > > SELECT authorname FROM author INNER JOIN book INNER JOIN bookauthor ON > book.Id_book = bookauthor.Id_book ON author.Id_author = bookauthor.Id_author > WHERE bookltitle='title' >
you have no join clause between book and bookauthor. How should those two tables be joined? How about FROM author a JOIN bookauthor ba ON a.Id_author = ba.Id_author JOIN book b ON ba.Id_book = b.Id_book WHERE .... > > > I receive an error when I execute this Query saying > > "SQL Error" > > > > Is it me or is it SQLite? > > Or a bit of both? > > > > Pls help me > > > > Thanks > > Ralf > > > > > > ____________ > Virus checked by G DATA AntiVirusKit > Version: AVK 18.4478 from 13.07.2008 > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users