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?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé