posted 18 years ago
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.