I am trying to create a INSERT SELECT statement which inserts and converts data from `Imported_table` to `Destination_table`.

**Imported\_table** 

```
+------------------+-----------------------+
| Id (varchar(10)) | genre (varchar(4000)) |
+------------------+-----------------------+
| 6                | Comedy                |
+------------------+-----------------------+
| 5                | Comedy                |
+------------------+-----------------------+
| 1                | Action                |
+------------------+-----------------------+

```

**Destination\_table** (How it should be looking)

```
+-----------------------------+----------------------------+
| genre_name (PK,varchar(50)) | description (varchar(255)) |
+-----------------------------+----------------------------+
| Comedy                      | Description of Comedy      |
+-----------------------------+----------------------------+
| Action                      | Description of Action      |
+-----------------------------+----------------------------+

```

* `Imported_table.Id` isn't used at all but is still in this (old) table
* `Destination_table.genre_name` is a primairy key and should be unique `(distinct)`
* `Destination_table.description` is compiled with `CONCAT('Description of ',genre)`

**My best try** 

```
INSERT INTO testdb.dbo.Destination_table (genre_name, description)
SELECT DISTINCT Genre,
       LEFT(Genre,50) AS genre_name,
       CAST(CONCAT('Description of ',Genre) AS varchar(255)) AS description
FROM   MYIMDB.dbo.Imported_table 

```

Gives the error: `The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.`

Thanks in advance.