• 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
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!