I am a beginner in SqlServer. I have a table that contains values and their IDs :

```
IDMark |  Mark
 1        Dell
 2        Sony

```

and another table Essai that contains a SerialNumber and the Mark :

```
SerielNumber | Mark
  DF34F        Dell
  34RTB        Dell

```

The table above had 133 rows. 

I want to insert into another table all the 133 rows's Ids mark, something liek this 

```
SerialNumber  |  Mark
  DF34F          1
  34RTB          1

```

I have used a subquery, but it retieves only undiplicated rows. It's like a distinct, it return only 2 rows. This is my query 

```
select idMark from Marque where mark in (select mark from ESSAI)

```

It returns only two rows
Also how can I insert the result into my new table ? should I use a procedure or a fetch ?? I really don't know.