jQuery in Action, 3rd edition
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: 43885
. . . and welcome to the Ranch
Have you checked out Aspose?
subject: Newbie with queries
It's not a secret anymore!