I have two tables, created at runtime, which pulls some data from some entirely different tables and joins and complex where clauses, and finally, I have these two tables with columns something like this:

**TableCars:** 

```
Id    Company    Views
```````````````````````
01    Honda        12
32    audi         6
18    BMW          3
17    Vector       5

```

**TableBikes:** 

```
Id    Company    Views
```````````````````````
01    Honda        3
32    audi         1
19    Kawasaki     2

```

**Note:**  

company names and id's will always be the same in these two tables, like, `honda = 01`

I want to merge these two tables in the sense that I dont want any repetitions in the names (or id's) and I want the views to be added. Is there any way to do this without using a while loop and a whole lotta hair loss? 

the resultant table should be something like this:

**ResultantTable** 

```
Id    Company    Views
``````````````````````
01    Honda        15
32    audi         7
18    BMW          3
17    Vector       5
19    Kawasaki     2

```

Many thanks in advance.

ps: I tried to check google, came across "merge" clause, looked up on that, MSDN was way over my head. I never understand ANYTHING in MSDN. wonder if there are any other people like me.