getting error when passing multiple argument

Its pretty hard to guess/read your mind with very limited/ambiguous information. I am trying to propose a solution which may need some bit of tweaking. You need to modify your sql in a way similar to below sql. You also need to avoid concatenating strings which are open to sql injection attacks.

Select	hotel_facilities.hotel_id, wifi,restaurant,Transport,Exercise,Business,FoodBar,Casino,Swimming,Shopping,Wheelchair 
from	hotel_facilities
		INNER JOIN hotel_Addrecord on hotel_facilities.hotel_id = hotel_Addrecord.hotel_id
where	hotel_facilities.hotel_id = {some_id} AND
		(wifi + restaurant + Transport + Exercise+Business+FoodBar+Casino+Swimming+Shopping+Wheelchair) is not null

Below is a running example

Select	hotel_facilities.hotel_id, wifi,restaurant,Transport,Exercise,Business,FoodBar,Casino,Swimming,Shopping,Wheelchair
from	
(
		select 1 as hotel_id, 
			   'Yes' as wifi,
			   'Yes' as restaurant,
			   'Yes' as Transport,
			   'Yes' as Exercise,
			   'Yes' as Business,
			   'Yes' as FoodBar,
			   'Yes' as Casino,
			   'Yes' as Swimming,
			   'Yes' as Shopping,
			   'Yes' as Wheelchair 
	    UNION ALL
		select 2 as hotel_id, 
			   'Yes' as wifi,
			   'Yes' as restaurant,
			   'Yes' as Transport,
			   'No' as Exercise,
			   'Yes' as Business,
			   'Yes' as FoodBar,
			   NULL as Casino,
			   'Yes' as Swimming,
			   'Yes' as Shopping,
			   'Yes' as Wheelchair 
	    
) hotel_facilities
		INNER JOIN 
		(
			select 1 as hotel_id
			UNION ALL 
			select 2 as hotel_id
		)hotel_Addrecord on hotel_facilities.hotel_id = hotel_Addrecord.hotel_id
where	hotel_facilities.hotel_id = 1 AND
		(wifi + restaurant + Transport + Exercise+Business+FoodBar+Casino+Swimming+Shopping+Wheelchair) is not null

Usually developers are not good in writing SQLs. Try reading a good book of SQL.