A
a
Available dates (you can say table1)
Begin date end date
1/1/2004 10/1/2004
------
Reservation dates (you can say table2)
Begin date end date
1/1/2004 4/1/2004
8/1/2004 10/1/2004
------
The difference date (not occupied date) not booking date
The result what I want to get
5/1/2004
6/1/2004
7/1/2004
What I want to say the question:
Give me the date not in reservation dates
Using (query or sql)
I hope you can understand my question and can help.....
this is hotel reservation system to know what is avilable what is reserved
what is free (not reserved)
Thank you
Begin date end date
1/1/2004 10/1/2004
------
Reservation dates (you can say table2)
Begin date end date
1/1/2004 4/1/2004
8/1/2004 10/1/2004
------
The difference date (not occupied date) not booking date
The result what I want to get
5/1/2004
6/1/2004
7/1/2004
What I want to say the question:
Give me the date not in reservation dates
Using (query or sql)
I hope you can understand my question and can help.....
this is hotel reservation system to know what is avilable what is reserved
what is free (not reserved)
Thank you