Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to retrieve repeated data from detail Table
Versions des environnements
Network:
Windows 2000 Server
All experts,
when i retrieving data from the sql server using 'Select' satament with more than one conditions(Say, flag = .f. and Amount > 0
etc...), It retries duplicate records. But i supressed it by using 'Select Distinct statement', And it working fine.
But, In some situations i requred repeated items from the 'detail table'(eg. There is a possiblity of same 'Part No.' can be entred in two times). In this situation how will i fetch the same part nos. ?, The problem is, if i m using simple 'select statement' it wil retrieve duplicate records and if i use 'Select Distinct statement' it will eliminate the second entry of the same item.
please i need someones helping hand in this regard.
regards
Abdulla
Suivant
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