select lieu_id,pro_id,heb_id,mea_date_debut,mea_date_sejour,mea_duree,mea_activite 
,meat_id,isnull(mea_pack,'0') as pack, FORMULE_ID 
 from mise_en_avant as mea ,mise_en_avant_type as meat 
 where mea.mea_id = meat.mea_id and mea.mea_id= 205<br><!-- temps de reponse=0 s-->