I've a problem building a data model for HR APP.
- I have 2 different tables of measures, each table is connected to the other by the PERSONAL_ID and date FROM date TO
Table 1 : PERSONAL_DATA
Table 2: CONTRACT
What i need is to be able to use a CALENDAR table, that if I select DATE: 20160116 and the result be like:
And if i select whole January:
I tried to build a LINK table between the Calendar and the 2 tables and i doesn't work properly
I tried to concatenate both tables and link the calendar by a link table ( Datelink, Date) and it doesn't either.
How you would build the data modeling without increasing the 2 tables registers?