Min Date but No Max date

[#1]

Dear All,

I have a big question to ask for help :

1 Have 3 tables :

1 table property contain : property_id and property name

1 table property_category contain property_id, parent, category, min_date as time_period, haskey(min_date,property_id) key

The basic is the property can change the parent and category at any given time - so there will be duplicate property in there

1 table contains date as time_period_id, property and $$$allocated,haskey(date,property_id) key

The problem is the pivot table :

the parent and category only shows when the key is match but in other week it does not.

the other weeks should be shown as well because the category and parent actually should be in the date range.

Would you guys kind enough to show me the way ?

Thanks

Senjaya