Oops... Forgot your stars. :)

Did I tell you this worked? I don't remember and it's a pain to read a message while editing one. Anyway, I put the subselect on the history part to eliminate those in current already. Worked great.

Thanks,

Michelle


>
>You may want to try using where clause like
>WHERE a_pomast.purno is not in (SELECT purno, potype, purdate, currid, postat, puramt, recamt, vendno, company, "H" AS chfile) - normally SBT has a field that with current mark(X) to let you know that the record is have been moved to history.
>
>Carl