SageTeamZZ
New Member
- Joined
- Jul 3, 2019
- Messages
- 3
I have two tables one of them contains a particular's distinct values as a primary key. and another table consists the same particular's multiple values for different dates along with few more details. now based on some conditions i want to bring the outcome count to the first table for further calculation
I HOPE ANY HUMBLE PERSON WILL BE HELP ME ON THE FORMULA
Data Model for both of the tables has been mentioned in the below.
thanks in advance
<tbody>
</tbody>
<tbody>
</tbody>
I HOPE ANY HUMBLE PERSON WILL BE HELP ME ON THE FORMULA
Data Model for both of the tables has been mentioned in the below.
thanks in advance
Table-1 | |
Distinct Line No | Capacity |
L1 | 60 X Count of Working Days (From Table 2) |
L2 | 60 X Count of Working Days (From Table 2) |
L3 | 60 X Count of Working Days (From Table 2) |
L4 | 60 X Count of Working Days (From Table 2) |
<tbody>
</tbody>
Table-2 | ||
Line No 1 | Date | Status |
L1 | Wednesday, July 3, 2019 | Working |
L1 | Thursday, July 4, 2019 | Working |
L2 | Wednesday, July 3, 2019 | Working |
L2 | Thursday, July 4, 2019 | Working |
L3 | Wednesday, July 3, 2019 | Working |
L3 | Thursday, July 4, 2019 | Holiday |
L4 | Wednesday, July 3, 2019 | Working |
<tbody>
</tbody>