string str="Men's Interest"; Select a.Category_Id, a.Category_Name,b.umc,b. Magazine_Name,Magazine_Description From [magazine_category] a Inner Join magazine b on a.Category_Id = b.Category_Id and a.Category_Name = '"+str+"'"
It will run properly
string str="Men's Interest"; Select a.Category_Id, a.Category_Name,b.umc,b. Magazine_Name,Magazine_Description From [magazine_category] a Inner Join magazine b on a.Category_Id = b.Category_Id and a.Category_Name = '"+str+"'"
It will run properly