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

Reply via email to