File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 46383
. . . and welcome to the Ranch
I agree. Here's the link:
subject: Newbie with queries
It's not a secret anymore!