Hey guys!
I need something printable. In my case, it's message history.
I got recipient(s) and their messages.
I can't use the Data Reports because, it only allows 1 query return. In my case, I have to do 2 query returns.
User table:
UserID Name
1 User, One
2 User, Two
3 User, Three
Message table:
MsgID Recipient Body
1 2 "Hello"
2 1,2 "Hi"
3 1,2,3 "Bye"
The way I get the recipients name is to take The field Message.Recipient and parse each UserID by doing a select Name query on User table. Then I combine that with the Message.Body after.
How am I gonna do those 2 query on a Data Report?
Or is there a 1 select query that I can do for SQL that'll do that for me in 1 shot?
Like, get the messages with Recipient # 1.
Thanks!
I need something printable. In my case, it's message history.
I got recipient(s) and their messages.
I can't use the Data Reports because, it only allows 1 query return. In my case, I have to do 2 query returns.
User table:
UserID Name
1 User, One
2 User, Two
3 User, Three
Message table:
MsgID Recipient Body
1 2 "Hello"
2 1,2 "Hi"
3 1,2,3 "Bye"
The way I get the recipients name is to take The field Message.Recipient and parse each UserID by doing a select Name query on User table. Then I combine that with the Message.Body after.
How am I gonna do those 2 query on a Data Report?
Or is there a 1 select query that I can do for SQL that'll do that for me in 1 shot?
Like, get the messages with Recipient # 1.
Thanks!