Question: Huh, this is the simplest title that I could think of.

So this is my problem. I have two table (data for example): 
Table: 

```
EMPLOYEES
=====================================================
ID    NAME    SUPERVISOR    LOCATION    SALARY
-----------------------------------------------------
34       John                  AL          100000
17       Mike    34            PN          75000
5        Alan    34            LE          25000
10       Dave    5             NY          20000

```

And second table (data for example):

```
BONUS
========================================
ID        Bonus
----------------------------------------
17        5000
34        5000
10        2000

```

I have to select employee's name, supervisor's name and bonus of everyone who got a bonus greater than 1000. So I wrote this query:

```
SELECT e.name, e.supervisor, b.bonus from employees e join bonus as b on b.empid = e.empid where b.bonus > 1000

```

But I dont know how to replace supervisors ID with name to get this result:

```
RESULT:
=====================================
Name     Supervisor    Bonus
-------------------------------------
Dave     Alan          2000
John     -             5000
Mike     John          5000

```

Can you please help me? I'm really out of ideas...

Answer: 
Using the right field would be a good start. You've specified that `ListId` is required, but you're never using `ListId`, but rather `txtListId`. You should really use Razor helpers to generate your inputs:

```
@Html.TextBoxFor(m => m.ListId)

```

Short of that, just name your input properly:

```
<input type="text" name="ListId" />

```
To display the validation message, assuming that you are using Razor view engine and your view is bound to the model **Todo**, you must use the following line:

```
<%= Html.ValidationMessageFor(m=>m.ListId) %>

```

This will cause the validation message to be displayed on the page. Hence, your view must look something like this:

```
@Html.TextBoxFor(m => m.ListId)
<%= Html.ValidationMessageFor(m=>m.ListId) %>

```

Also, in the controller, you need to have a check for validating the model state:

```
if (ModelState.IsValid)
{
    //take some action
    //maybe, add to DB or whatever
}
else
    return view(); // render the view again

```