File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JBoss/WildFly and the fly likes 1-M relationship & join queries? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "1-M relationship & join queries?" Watch "1-M relationship & join queries?" New topic

1-M relationship & join queries?

Jolie Lee
Ranch Hand

Joined: May 08, 2005
Posts: 87
i have a 1-M relationship defined in ejb-jar.xml for table A and table B.

table A consists of:
id (PK)

table B consists of
bid (PK)
id (FK)

i want to do a search based on the name on table A, and when user search, i want to be able to get the version on table B as well.

how can i do that? do i need to have a join query in my jboss-jdbc.xml?

pls advise.

Jys<br /><a href="" target="_blank" rel="nofollow"></a><br /> <br />Trying my very best to learn java, please forgive me if i'm asking some really stupid questions.
I agree. Here's the link:
subject: 1-M relationship & join queries?
It's not a secret anymore!