I have a SQL Server database of hotels, and 3 tables of criteria, I need to be able to select hotels which meet the criteria.
Hotels contains Hotelid, Name etc
table a contains hotelid, 'Type of Activity' (ie Beach, NightLife etc)
table b is similar to 'a' BUT holds spa info (ie detox, weight loss etc)
table c again similar to 'a' BUT holds Traveller info (i.e Solo Traveller, Honeymoons etc)
I want to create a storeprocedure that allows me to select the Hotelid and name which meet the selected criteria ie Hotels that have Beach, Nightlife, detox and honeymoons etc
I can get it to work for single selections from each table BUT get no data returned when I try to add two or more selections from either tables a, b or c