select it.C_Code,it.C_Name, it.C_Pack, gd.c_item_code,gd.n_qty from tbl_gdn_stock g join tbl_gdn_stock_details gd on gd.n_srno=g.n_srno inner join Tbl_Item_Mst it on it.C_Code=gd.c_item_code where g.c_empid='4614' and g.c_year=2015 and MONTH(g.d_date)=01
tbl_item_mst result
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)