I was getting confused on how to build the SQL query when it come to joining two tables so that I could bind them later to a gridview.

Basically I have two tables,

```
tablename: family
 __________________________
|Status |lastName|firstName|
|-------|--------|---------|
|1      |11      |111      |
|2      |22      |222      |
|3      |33      |333      |
''''''''''''''''''''''''''''
            +

tablename: familyStatus
 _____________________
|id        | Notes    |
|----------|----------|
|1         | 1111     |
|2         | 2222     |
|3         | 3333     |
'''''''''''''''''''''''

           =

Joined-tables: family+familyStatus [this is what i want]
 ____________________________
|firstName | lastName |Notes |
|----------|----------|------|
|111       | 11       |1111  |
|222       | 22       |2222  |
|333       | 33       |3333  |
''''''''''''''''''''''''''''''

```

what your seeing here is that the **Status** from table **family** and **id** from **familyStatus** is the same key, status and id will be hidden on the gridview.

```
Lets just assume for now that this is how i get the family table.

SELECT Status, firstName, lastName
FROM family
WHERE firstName= @fN
AND lastName = @lN

```

What do I need to add here so that the Notes from family table also gets joined?