I am stuck on creating a SQL query. I have the following two tables:
member ( memberid int, membername varchar(50) ) message ( messageid int, message varchar(100), sender int, receiver int )
sender and receiver are foreign keys with table member and column memberid. I want to display list of messages with name and id of sender and receiver.
How can I establish proper joins here?
Advertisement
Answer
You can try something like
SELECT *
FROM message m INNER JOIN
member snd ON m.sender = snd.memberid INNER JOIN
member rcv ON m.receiver = rcv.memberid