Sql Display information from 3 tables row by row

Question

HI i havind table like stindent,zpindent,Tpindent table

 

in this tables COunt(drugs),SUM(qty),SUM(fundamt) group by finyear

same like other tables bt columns name difference 

 

i want to display this three table data in one gridview like this formate ST table,Zp Table ,Tp Table

 

	Sl. No.	Fin Year	Sector			No. of Drugs	Qty. of Drugs	Indent Amount	Action
	1	2019-20	ST						view
	2	2019-20	ZP						view
	3	2019-20	TP						view
	4	2018-19	SS						view