• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

query problem

 
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?

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic