getting error when passing multiple argument

Question

sir i want to retrieve those values which is not null. i have written this query but getting error. please help.

my query is :-

 

 SqlCommand sqlcmd = new SqlCommand("Select wifi,restaurant,Transport,Exercise,Business,FoodBar,Casino,Swimming,Shopping,Wheelchair from hotel_facilities where wifi,restaurant,Transport,Exercise,Business,FoodBar,Casino,Swimming,Shopping,Wheelchair is Not null in(Select hotel_name from hotel_Addrecord where hotel_id='" + getid + "' )", sqlcon);