Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

iggyntangs · 04-08-2011, 10:13 AM

I think I figured out the 1st query...

Another query I wanted help on was that if a guest wanted a certain type of room then if that type of room would be available on the dates they wanted to stay on.

I used JUST the Reservation table but I'm not sure if that quite would do what I want, here's what I currently had:

Select villa_type from reservation
where res_check_in_date not between '2011-10-08' and '2011-10-09'
and res_check_out_date not between '2011-10-08' and '2011-10-09'

04-08-2011, 10:13 AM	#5
iggyntangs Scoring Winger Join Date: Oct 2010 Exp:	I think I figured out the 1st query... Another query I wanted help on was that if a guest wanted a certain type of room then if that type of room would be available on the dates they wanted to stay on. I used JUST the Reservation table but I'm not sure if that quite would do what I want, here's what I currently had: Select villa_type from reservation where res_check_in_date not between '2011-10-08' and '2011-10-09' and res_check_out_date not between '2011-10-08' and '2011-10-09' Last edited by iggyntangs; 04-08-2011 at 10:18 AM.