Firebird SQL join tables

Currently I have tables like these:

Table Customer

ID Name 01 Angel 02 Charlie 

Table Input1

Name Value Charlie 5 Angel 7 Charlie 10 Angel 3 

Table Input2

Name Value Charlie 10 Angel 5 Charlie 15 Angel 25 

How to get result like this

Name Input1 Input2 Angel 10 30 Charlie 15 25 

1 Answer

Try this:

SELECT c.Name, i1."Value" value1, i2."Value" value2 FROM Customer c LEFT JOIN (SELECT Name, SUM("Value") "Value" from input1 group by Name) i1 ON c.Name = i1.Name LEFT JOIN (SELECT Name, SUM("Value") "Value" from input2 group by Name) i2 ON c.Name = i2.Name 

DEMO