SELECT *, SD_Serie_Ligne.idGammeArticle, SD_Serie_Ligne.ordre  FROM         vGRN_ARTICLE_GRN_ARTICLE_NON_STOCK a INNER JOIN  SD_GammeArticle s ON a.arcod = s.RefArticle INNER JOIN  SD_Serie_Ligne ON s.id = SD_Serie_Ligne.idGammeArticle  where a.arutil='Non' and arcod=refarticle and s.societe='HYGIALIM' and a.societe='HYGIALIM' and gammeID=426688 AND s.id in( 7777307,7777299,7777300,7777301,7777302,7777303,7777304,7777306,7777305,7777308,7777309,7777310) AND exists (select * from SD_Serie where id = SD_Serie_Ligne.idSerie) ORDER BY SD_Serie_Ligne.Ordre