This sounds to be a pretty much straight solution
Something like following should do your job-
SELECT Table1.Name, COUNT(Table2.ID),Table1.Target
FROM Table2
INNER JOIN Table1 ON Table2.ID=Table1.ID
GROUP BY Table1.Name,Table1.Target
Note: Uncomment the INSERT statement once you are sure about the accuracy of the result from the SELECT statement, to insert the result in to Table3.
Hope, it helps :)