CHAMPIONNAT DE FRANCE   

select *,res_en_ligne.sexe as M_F FROM res_en_ligne INNER JOIN RACES ON res_en_ligne.Codif_race = RACES.ID LEFT OUTER JOIN dbo.chiens ON res_en_ligne.ID_Ch = chiens.TATOUAGE where expo = 3397 and codif_race = 10821 order by cat