You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by kishore talagadadeevi <kt...@hotmail.com> on 2004/09/10 04:46:21 UTC
MULTIPLE TABLES - DATA retrieval
I really appreciate if someone could suggest me on the following ..
I have three independent tables .
All three tables have part_num and part_serial as part of composite primary
key in addition to other columns.
Question: How do I retrieve qty,cost and size by joining all three tables
on part_num and
part_serial columns using OJB ???
How do I define this scenario as a class descriptor in
repository.xml file ???
T_PARTA T_PARTB T_PARTC
part_num(pk) part_num(pk) part_num(pk)
part_serial(pk) part_serial(pk)
part_serial(pk)
system(pk) type(pk)
dimension(pk)
qty cost size
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org