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

Reply via email to