I'm having a problem writing the correct sql to bind togeather three
tables. Here's the problem: I have a table for detail information on
books that are in our catalog, and a table for authors. Unfortunatly, it
is not a one to one relationship. Some books are written by several
authors, hence, I've created an intermidiate table called book_to_author
where I list the isbn's for the books next to the author id's, so I may
list an isbn three times with three different author id's next to it, if
three authors have contributed to it.
Now I have to write a sql statement that will pull up the book detail
info, such as the title, and the three authors associated with it.
Assuming I have a table called authors, with an author name in it, one
called book_to_authors, with the isbn and author_id, and a third called
books, with the title in it, how would I write the sql to join all the
info where the isbn='0530725318?
Thanks a million if you can help. I've been trying to write this all
morning, and can't get it to work.
Bill
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!