Hello,
I have searched the forum for related problems, though I have found a few, I was unable to apply them to my database. So here it goes:
This is a n:m relationship.
Three tables: author, speech, speech_author.
Table author: the usual stuff, with no column linking to speech or speech_author.
Table speech: same as above.
Table speech_author: this is the look-up table that has the author_id and speech_id.
The result I need is a list of speeches with the author name next to it. I.E.:
author_name, speech_title.
If there are authors that do not have speeches, then the author should be omitted. This basically is a list of speeches.
I have tried applying JOIN, INNER JOIN, OUTER JOIN, NATURAL JOIN, but kind of have no idea how to organize them. I am reading several MySQL books, but none of them seems to show queries for look-up tables.
Thanks!