Query not going right
Posted 20 September 2006 - 03:58 PM
Members - has user info to include (UserId, Username)
MessageInfo -has (MessagetId, MessageFrom, MessageTo)
MessageText - (MessageId, PostText)
I want to query these together together and I'm not sure how to tie the 3 together. I can quest each individually but I'm having no success getting a query that incorporates them all.
Anyone have any suggestions?
Posted 20 September 2006 - 05:31 PM
Members = fields Userid, username ect...
MessageInfo = fields MessageID, Userid, MessageFrom, MessageTo ect...
MessageText = MessageID, PostText ect...
By adding the Userid in the message info table you can now link like so:
Members.Userid = MessageInfo.Userid AND MessageInfo.MessageId = MessageText.MessageId
Hope that helps
Posted 20 September 2006 - 06:25 PM
Members = fields: Userid, username ect...
MessageInfo = fields: MessageID, Userid, MessageFrom, MessageTo ect...
MessageText = fields: MessageID, PostText ect...
Anyhow couldn't this be done:
- take the MessageInfo, which has the same field "MessageID", link to MessageText's "MessageId" to get the "PostText"
- then link the MessageInfo's "UserId" to the Members' "UserId" to get the "Username" for the "MessageFrom" and "MessageTo" ?
that being said and if it can be done, can anyone help me figure out how to do it?
Posted 21 September 2006 - 01:04 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users