While inserting into target table i am getting an error '"not enough data columns;target has 3 but the inserted data has 2" but it's the identity column which is the 8th column ".

insert into table A

(col 1,col 2,col3)

select

col2,

col3

from table B

join table C