Summation using columns from different table.

[CK_WAKE]

Hi There,
I have three tables. Due to a technical issue, I cannot join them together, but I need to perform a summation.
Example as below: I would appreciate it if you could educate me on this, thanks

TABLE 1			TABLE 2			TABLE 3			Summation
ID	TABLE 1 KPI		ID	TABLE 2 KPI		ID	TABLE 3 KPI
A	10		A	100		A	60		170
B	20		B	200		B	70		290
C	30		C	300		C	80		410

[CK_WAKE · Accepted solution]

Hi There,  please ignore, i was able to do it and below is the logic i used and it shows correct values

with actual data below.
Max(WO_COUNT_KPI) + Max(K1VA_AGE_KPI)+ Max(NOMINAL_VOLTAGE_KPI)+Max(EQUIPMENT_AGE_KPI)