I have two tables in MySQL:

**\_\_\_Table1**

```
| id | name |
|----|------|
| 98 | Fred |

```

**\_\_\_Table2**

```
| link | amount |
|------|--------|
|   98 | 100.00 |
|   98 |  50.00 |

```

How can I `SELECT` all the items from \_\_\_Table1 and `SUM` datas from the \_\_\_Table2.

The desired output should be:

* Fred = 150.00

This is what I have tried so far:

```
SELECT 
SELECT SUM(amount) AS amount FROM ___Table2 WHERE ___Table2.link = ___Table1.id,
(SELECT * FROM ___Estimates ORDER BY EST_Id DESC)

```

Thanks.