Hi!
I read bunch of examples, but I have troubles to "translate" my SQL query to JPQL query. SQL query is something like this:
Code:
select store.id, ifnull(sum(stock.number),0)-ifnull(sum(storeorder.number),0) from item
join orderitem on (item.id=orderitem.iditem)
join storeorder on (orderitem.id=storeorder.idorderitem)
join store on (storeorder.idstore=store.id)
left join stock on (item.id=stock.iditem)
where item.id = '71' -- This could be parameterized
group by store.id;
In the Stock table new records are added when new items are added to some Store. When Item is sold, then record to the StoreOrder table is added. I want to get current stock for every store for given itemID.
For example, result set would be:
Code:
Store 1 33
Store 2 5
Store 3 3
Store 4 66
Any help? :)
Login
FAQ
Search