Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TheKai
Starting Member
16 Posts |
 Posted - 2010-04-05 : 22:21:41
|
| Thanks for taking a look at my question! :)I have two tables:TABLE People------------PersonID intPersonName varchar(100)TABLE Messages------------MessageID intTimeSent dateSender intReceiver intI'm trying to get a result set that looks something likeRESULT-----------------------MessageID , TimeSent, SenderID, SenderName, ReceiverID, ReceiverNameMessageID , TimeSent, SenderID, SenderName, ReceiverID, ReceiverNameI've only been able to devise a implicit join query that returns ONE of the persons's names, not both because it contains a "WHERE Messages.Sender = People.PersonID" clause.Can you help me figure out what the apropriate query might look like?Thanks in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-04-05 : 22:36:39
|
[code]select m.MessageID, m.TimeSend, m.Sender, s.PersonName as SenderName, m.Receiver, r.PersonName as ReceiverNamefrom Messages m inner join Person s on m.Sender = s.PersonID inner join Person r on m.Receiver = r.PersonID[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
TheKai
Starting Member
16 Posts |
Posted - 2010-04-05 : 22:55:04
|
quote:
Originally posted by khtan
select m.MessageID, m.TimeSend, m.Sender, s.PersonName as SenderName, m.Receiver, r.PersonName as ReceiverNamefrom Messages m inner join Person s on m.Sender = s.PersonID inner join Person r on m.Receiver = r.PersonID
KH[spoiler]Time is always against us[/spoiler]
Aha! Thanks to you both! I didn't know you could do a multiple inner like that. Very cool. I learned something new! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
(probably simple) Join Question