I just can't get my head around this ...
Customers can book apartments online these are stored in a table [tblNoBooking] the second table tells us how many apartments there are of each type [tblRoomTypes] for example there maybe 6 2 bedroom apartments.
What I NEED is an SQL and/or asp code which looks up and tells me how many apartments are left based on a simple form which is
startDate and endDate of period
The query needs to show all 4 apartments and the number of apartments left
The form posts is request("from") request("to")
Bu iş için 2 freelancer ortalamada $45 teklif veriyor
I have more than 5+ years and developed more than 50 E-Commerce sites. Quality is a way of life - we ensure that there is quality work at every step. I shall continuously strive to exceed the expectations of our cu Daha Fazla