SELECT
    od.*, pr.*
FROM
    OrderDetails AS od
JOIN
    Products AS pr
ON
    pr.ProductID = od.ProductID;