
/* Selectionner les articles d'un document d'achat fournisseur */

SELECT ART.AR_REF  FROM F_ARTICLE ART join F_DOCLIGNE LIG on LIG.AR_Ref = ART.AR_Ref join F_DOCENTETE DOE on DOE.DO_Piece = LIG.DO_Piece
WHERE DOE.DO_Piece = 'FFA00024'