Here's what I entered to create a cursor for a report

select produit.code, produit.nom, produit_prix.prix_achat, produit.stoc;
from produit;
left outer join produit_prix on produit.code = produit_prix.cod;
where produit.produit = 1;
order by produit.code

But certain items are doubled others tripled.

What I want to do is to get prices for some products. Some products don't have prices defined yet (outer join is needed).

Why would I have those results?