This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills and have John Sonmez on-line!
See this thread for details.
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


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "1-M relationship & join queries?" Watch "1-M relationship & join queries?" New topic
Author

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)
name


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

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="http://jy-s.com" target="_blank" rel="nofollow">http://jy-s.com</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: http://aspose.com/file-tools
 
subject: 1-M relationship & join queries?