Copying specific fields from table to table

I've got 2 tables. One table which contains a series of barcodes assigned to product id #'s, and another table with JUST product id #'s. I need to somehow transfer all the barcodes from the first table into the second table, but only where the id #'s match. Can anyone tell me if this is something that can be done with just a SQL statement, or do I need to write a PHP script to loop through the records of both tables and do the copying/mapping?