Select into existing table where ID is in another table
The SELECT ... INTO syntax is only for new tables. 
I think you want:

INSERT dbo.TableB ( &lt;column list&gt; )
SELECT &lt;column list&gt;
FROM dbo.TableA
WHERE ID IN 
  (
    SELECT ID
    FROM dbo.TableC
  ) ;