I have two tables

**Unit**

```
Unit_id
Unit_name
Unit_cost

```

**Components**

```
Component_id
Component_name
Unit_id

```

They are linked together by `Unit_id`.

`Unit_id = 1` with name `Unit 1 Name` with a cost of 100 has a number of records in `Component`.

`Unit_id = 2` with name `Unit 2 Name` and a cost of 200 also has a number of records in `Component`.

So the total cost depends on the number of records in the `Component` table matched with the `unit_id` in the `Unit`, coupled with the `unit_price` in the `Unit` table.

I need the single `Unit_name` of the one unit in the `Unit` table that has the highest total cost (`Unit.Unit_cost`). Note I just need the `Unit_Name` only, not total cost.

Would it be best to use a `Top(1)` in the query? How would the query look?