i have table Reservation_tb
which I select gest ,hotel name and select period from date and to date
how I get single room rate from rates which in Hotel_RATE_tb which different from date to date
I need query to get this rate for ( if gest will stay in hotel three days )
eva from 02/02/2019 to 05/02/2019 in JWM Hotel
lookup in table Hotel_RATE_tb
first day rate will be 500
second day will be 500
third date will be 450
thanks in advanced for help
which I select gest ,hotel name and select period from date and to date
how I get single room rate from rates which in Hotel_RATE_tb which different from date to date
I need query to get this rate for ( if gest will stay in hotel three days )
eva from 02/02/2019 to 05/02/2019 in JWM Hotel
lookup in table Hotel_RATE_tb
first day rate will be 500
second day will be 500
third date will be 450
thanks in advanced for help