I want to insert data into a column in the table.

```
Table a
ID  col1  col2
1    A    null  
2    B    null

Table b
ID  col1 
1    C
2    D

```

Expected results:

```
Table A
ID   col1  col2
1     A     C
2     B     D

```

I tried this:

```
insert into tableA (col2) 
select b.col1
from tableB b , tableA a
where b.id = a.id

```

and I received

```
0 row inserted.

```

How do I insert the col1 in B into col2 in A for the matching 'id' columns?

Thank you.