Check your FROM Clause you have used CustomerDetail and ProductRelation, so from where ProductDetail alias comes?
Try this
SELECT
cd.CustomerName
,cd.CustomerAddress
,pr.ProductName
FROM
CustomerDetail AS cd
INNER JOIN ProductRelation as pr
ON pr.RelationId = cd.RelationId