General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only