My current solution to the problem is PHP and it - simply put - sucks
I loop through all the house records for a user using the following query
SELECT * FROM ce_house
LEFT JOIN ce_contract ON ce_house.house_id=ce_contract.house_id LEFT JOIN ce_contract_status
Hi,I have one to many (from left to right) relationships among the below tables in my databaseuser -> house -> contract -> contract status |Also, a single house has a single provider and the provider has multiple
rates inside the provider_rate table in chronological order.I have a que
