How to get values from 2 tables

[sani723]

hi,
i am new in SQL, i need this.

i have two tables (1) - Hotel (2) - Rates in 1st table i have fields autoid, name, rating, description and in
2nd table i have periodfrom, periodto, singleroomrate, doubleroomrate, RefHotelid
here period from and periodto are the datetime fields having the validatiy of rates tariff, suppose hotel A says
from this date to this date our rate sheet will be this but will be diferent from next month to additional 2 months
and RefHotelId is the basically the AutoId of the 1st Table, it can be repeated because single hotle can have many rate tariff
within a month or within a year.
so i wnat to select the name and description from first hotel where hotel rating is 2 and rest of the info means rates from 2nd table
based on selected autoid from 1st table for desired rating hotel how cna i get this.

like what i made query but it shows strange results.

select A.HotelName,B.SglPayableRate [Single Room Rate],B.DblPayableRate [Double Room Rate],B.TSUPayableRate [TSU Room Rate],B.QuadPayableRate [Quarter room Rate] from tblHotel A INNER JOIN tblHotelTariff B ON B.RefHotelID = (Select AutoID from tblHotel where StarRating = 2) AND PeriodFrom >= '5/25/2007' and PeriodTo <='6/2/2007'

[mabubakarpk]

Plz try this query when u have 1)Hotel 2)Rates tables

Code:
Select h.Name,r.Singleroomrate,r.doubleroomrate
from Hotel h inner join rates r on h.autoid=r.refhotelid
where r.periodfrom>='2007-01-01' and r.periodto<='2007-01-31'
and h.rating=2

[sani723]

Plz try this query when u have 1)Hotel 2)Rates tables

Code:
Select h.Name,r.Singleroomrate,r.doubleroomrate
from Hotel h inner join rates r on h.autoid=r.refhotelid
where r.periodfrom>='2007-01-01' and r.periodto<='2007-01-31'
and h.rating=2

dear this query is not returing anything although there are values against the date what i am entering

[mabubakarpk]

dear this query is not returing anything although there are values against the date what i am entering

I am surprised why it is not returning any value.Check the date format which u supply for filteration should be yyyy-mm-dd.

I try on following table structure
[Hotel table]

AutoID int 4 1
Name varchar 50 1
Rating int 4 1

[Hotel values ]

1 AWARI 1
2 PC 1
3 AKW 2

*************
[Rates table]

RefHotelId int 4 1
periodfrom datetime 8 1
Periodto datetime 8 1
Singleroomrate float 8 1
doubleroomrate float 8 1
[Rates table values]

1 01/01/2007 01/31/2007 500 800
2 01/01/2007 01/31/2007 400 600
3 01/01/2007 01/31/2007 200 350
1 01/02/2007 02/28/2007 550 1000
2 01/02/2007 02/28/2007 430 500
3 01/02/2007 02/28/2007 275 450
**************************
Query result which i send to u

AKW 200.0 350.0
**************************************
Practice this own ur side. I think you will got it now.

Regards,