SELECT * FROM Catalogue_Vente CV INNER JOIN Catalogue_Vente_Prix CVP ON CV.Sku=CVP.Sku AND CV.Pays_Id=CVP.Pays_Id LEFT OUTER JOIN Catalogue_Marques CM ON CM.MMarque = CV.Marque WHERE CV.Sku=157341 AND CV.Pays_Id=1