theres three tables, book_info, book_title, author
in book_info, you get author_id and book_id
in book_title, you get book_id and a field called title
in author, you get the author_id and the authors name
What I want to do is look in book_info, get author_id and book_id and display the book name and the author
Either a join or a union sounds right, unfortunately, I cant get much to work?
SELECT book_id, author_id FROM book_information INNER JOIN author ON book_information.author_id=author.author_id;
This is just me trying to get something to work, right now it says author_id is ambiguous, this sql query is not really what im looking for in the end, so if you can lead me into what I said Im trying to do, that would be helpful too. I dont know how joining three tables works, the tutorials im looking at only show two tables.
This post has been edited by NecroWinter: 22 September 2012 - 06:08 PM