Just add DISTINCT to your query, and combine them together into one:

select distinct art, material
from article

> For select all article into :art do
> begin
> Select material from article into :mat
> Do
> begin
> Suspend;
> End
> End

[Non-text portions of this message have been removed]