Merging tables and summarize a column

Hi everyone

I have 2 tables.

Table 1 contains these values for example:

The “capacity_total” is a single value for each date in combination with the “WorkCenterNo”

Table 2 contains these values for example:

The “capacity_used” has multiple Rows and values for the combinations of each date and “WorkCenterNo”. (Multiple Production Orders in a single day)

I would love to merge these two tables and get the combination of Date and WorkcenterNo once for each date. (Meaning I want to merge these tables and have a single value of “Capacity_Total” and “Capacity_used” for each combination of the date & WorkCenterNo, so I can calculate the utilization in percent)

The new table should look something like this:

If I could create that structure I could easily get the utilization in percent.

I hope someone could give me a helping hand with this.

Thanks for all the help in advance!