I am trying to calculate the space in a warehouse bin location.

I have the following data:

Table 1
Bin Location Item Quantity Total Spots Used
000-A-006 ABC1 100 2
000-A-006 CDE1 200 4
000-B-001 A2EW 250 5

Table 2
Bin Location Max Bin Capacity
000-A-006 25
000-B-001 15

I am looking for a simple one line total:

Quantity Max Bin Capacity Total Spots Used
550 40 11

I cant just join the tables because bin 000-A-006 is listed twice, but I only want the 25 for table 2 to be totaled only once but need the total quantity and total spots used

Thanks in advance…

I tried different different queries but I am getting multiple records in the output