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?