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