Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Newbie with queries

 
Narita Joardar
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need the message ids and endpoints of messages from whom endpoints in multicast_message_recovery_processed is not in the list of endpoints of the multicast_endpoints table, for a given prcs_id, prcs_run_id, multicast_id.

Data -

multicast_endpoints




multicast_message_recovery_processed




For a given `prcs_id = 100, prcs_run_id = 1, multicast_id = multiX`, the query should return:

1 destB
1 destD
2 destA
2 destC
2 destD
This essentially means that message 1 has not reached `destB` and `destD` while message 2 has not reached `destA`, `destC` and `destD`.



 
Ireneusz Kordal
Ranch Hand
Posts: 423
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try this query.
I shortended name of multicast_message_recovery_processed table since my database accepts only names up to 30 characters.

 
Campbell Ritchie
Sheriff
Pie
Posts: 50225
79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
. . . and welcome to the Ranch
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic