• 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?

Look ma! I'm selling my stuff!
the new thread boost feature: great for the advertiser and smooth for the coderanch user
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!