Small Mistake in your query change like below 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 = 'Men''s Interest'
I have insert sigle quotes near 's' a.Category_Name = 'Men's Interest' a.Category_Name = 'Men''s Interest' 2009/12/26 nag <[email protected]> > hi friend im getting following error,wen i run > DropDownList1_OnSelectedIndexChanged event > > Line 1: Incorrect syntax near 's'. > Unclosed quotation mark before the character string ' '. > > here is my query > please help me to solve this > > 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 = 'Men's Interest' > -- Regards ******************* *C.Arun Kumar * *******************
