its my first question, please bear me. I have following tables
id name description
id item_id(FK) branch_id(FK) purchaseRate date
id item_id(FK) branch_id(FK) quantity
I have to get all the items in specific branch(let suppose branch_id=1), its quantity in stock, its name, its description and its last purchase rates. This bold part is smashing my head.
LINK to fiddle: fiddle