c# or sql Inner Join

Question

if the preview doesnt come out right you can check the text file i post

Hi guys I really need help basically im trying to do a inner join update from table2 to table1. How to do the sql statement for this.

Example

table1

ID     Fruit     Color      ETag       Value

1      apple     red       TAG_TEST    4

2      orange    orange    TAG_TEST    3

3      cat       white     TAG_TEST    2

1      apple     red       TAG_TEST    1

1      apple      red      TAG_TEST    2

table2

Value     Etag

0         BAD

1         Good

2         pretty

3         ok

4         beautiful


table2 has the etag description of the value.
so 0 means bad, 1 means good, 2 means pretty etc.......

Im trying to pull the actual description from table2 and update the etag column where table1.Color -'red'

So basically im searching for the color red and the value red.