This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Newbie with queries Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Newbie with queries" Watch "Newbie with queries" New topic

Newbie with queries

Narita Joardar

Joined: Dec 15, 2011
Posts: 1
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 -



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

Joined: Jun 21, 2008
Posts: 423
Try this query.
I shortended name of multicast_message_recovery_processed table since my database accepts only names up to 30 characters.

Campbell Ritchie

Joined: Oct 13, 2005
Posts: 44590
. . . and welcome to the Ranch
I agree. Here's the link:
subject: Newbie with queries
It's not a secret anymore!