I hope that your second table has a
foreign key
linking the data with the first table.
Then use a
JOIN
on the tables:
SELECT table1.id, table1.Name, table1.Family, MIN(table2.Cash) as Amount
FROM table1 INNER JOIN table2 ON table1.id=Table2.table1id
Group BY table1.id, table1.Name, table1.Family