--- In firebird-support@yahoogroups.com, Lucas Franzen <luc@r...> wrote:

>
> UPDATE Versions SET
> Versions.DATA=-1,
> Versions.ATTRIBS=-1
> WHERE EXISTS
> ( SELECT * FROM Elems
> WHERE Versions.ELEM_ID=Elems.ID AND
> Versions.ID <> Elems.GOLDEN_ID AND
> Versions.NUM <= Elems.LAST_VER_NUM - 3
> );

This is just what I needed Lucas, thanks! I had tried this initially
but I most have done something to make it uncorrelated. This works great.

R.