Hello,

I have a question about distinct return values.

For example an article contained the following:

Piece A

Piece B

Piece C

Another article contained these:

Piece D

Piece E

AND Piece A.

Now I would return all contained Pieces, but only one time.

For select all article into :art do

begin

Select material from article into :mat

Do

begin

Suspend;

End

End

Can I check all returned values and if not present, then suspend? Or should
I save all values in a temporary table?

Thanks

Olaf
--
anything else:
I cannot use joins because the second step is more difficult (a called
stored procedure) select field from table a left join procedure b should not
work ;o)





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