I am knew to SQL and some help.
I have written a query
select CustomerNBR, Room, CheckinDt
from table a, table b
where checkindt between '07/01/2010' and '07/31/2010'
group by CustomerNBR, Room, CheckinDt
The reason I grouping by all three is a person might have multiple checkins on to the...