Frappe Cloud Support Partners Foundation Frappe School

Need query for query report

Hi, I have a table with name Stock Entry, I have another table inside that with name Item. I want to fetch item_group coulmn from Item table into Stock Entry table. How can I do that? Please tell me the query.