40367 ASP Query

Need help with a SQL query. I need to query a mysql database using ASP. I have 2 tables, 1 "users" and 1 "hotels". I need the hotel result to base on the option the user select when they first sigh-up. Example. user select: single room/Pool/Gym. I only want hotel with single rooms/pool and gym to be displayed.