INSERT INTO `products` (..........)


SELECT
book.ISBN,
........

collana.codiceCollana,
........

FROM

book
INNER JOIN collana ON (book.CollanaID = collana_ID)