Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

fetch data from two different schema

 
Sandeep Bhoyar
Greenhorn
Posts: 17
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Can any one know how t fetch data from two different schema using hql.

eg:
select orderId,orderDescription from order where companyId = (select companyId from company where id = 23432)

in this company table is in config schema and order table is in trans schema
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic