Query inside a query?

Elhombrebala

I have two tables in a DB, let's say one of the tables talks about services given by a hotel:
Table "Services"
- Hotel reference number
- Sauna
- Massage
- Spa
- Uva
The other table talks about availability:
Table "Availability"
- Hotel reference number
- week1
- week2
- week3
I wonder if it is possible to make a query that shows the reference numbers of all hotels having Sauna and Uva and being available week3.
To change tables is not a possibility.

Elhombrebala

I'm thinking about the question and I guess what I have to do is 2 different querys, one for "Availability" and the other for "Services", to place results in 2 arrays and after compare arrays creating a new array that contains only the coincidences.
But, how to?

LordShryku

You can do it in one query. You just need to use a join. You don't really explain enough about the tables for anyone to give you a straight answer. In the Availability table, if something's available, will it have anything in the table?

Either way, look up the join syntax in the manual. You should be able to just fetch whatever you want through the SQL

Elhombrebala

In both tables, if one element is true value will be 1.
If week 1 is available then value is 1
If Sauna is available value is 1
I'm looking at JOIN right now but I can not find how to use it in my case.

LordShryku

SELECT s.reference_number
  FROM services s, availabilty a
 WHERE s.reference_number = a.reference_number
   AND s.sauna = 1
   AND s.uva = 1
   AND a.week3 = 1