Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

query problem  RSS feed

Haris Tasawar
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hey all,

i have these two mapping XML`s for Inventory and ProductInformation tables respectively:

Now, i want to call a join statement on both of them using HQL..... so i defined a relationship in inventory XML and called this query

select pi.productCode , pi.productName , pi.barcodeNo , inv.saleunitprice , inv.quantity from Inventory inv join inv.ProductInformation pi

but it always fails with this error:

could not resolve property:ProductInformation of: tpos.Inventory

Can you guys please help me this?

Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!