Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
The current field doesn't work that way in PO, unfortunately.
That subselect looks like it would work, but I'm concerned about the speed of it. I'll play around with it and see how it does.
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement