File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "Newbie with queries" Watch "Newbie with queries" New topic
Author

Newbie with queries

Narita Joardar
Greenhorn

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 -

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

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
Sheriff

Joined: Oct 13, 2005
Posts: 39053
    
  23
. . . and welcome to the Ranch
 
GeeCON Prague 2014
 
subject: Newbie with queries