I have a table (tblRents)with the following fields:
RentID, LeaseID, StartDate, EndDate, RentalRate, TenantID and LessorID. For each lease entered, there could be several rent rates, each entered seperately with it's own RentID. I am trying to write a query that will give me each rent rate for the entire lease and the start and ending dates for each term. Basically, the LeaseID would be the same, but I am having trouble with the syntax. Any ideas?