Query inside query?
Posted: Wed Jan 14, 2004 10:06 am
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.
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.