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