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' 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