Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

cmp fetching values from 3 related tables  RSS feed

 
alec stewart stewart
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all
Friends can any one give me a short example of how i can fetch values from two or more related tables using cmp.
for eg tables employee and department are related. now if i implement a findall in employee cmp it returns me the dep_id and not its name.
i want to do something like this:
SELECT * from employee e ,department d where e.emp_id=d.dep_id
how can it be done through cmp (ejb-ql)
PLease it would prove to be a very helping hand if a friend among u can give me short example on this.
thanks to you all inadvance
 
Jesus Angeles
Ranch Hand
Posts: 2070
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you can look at cmr - container-managed-relationships

when 2 or more tables are related, you can use cmr
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!