General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
Thanks for Mr. Depak,
But Actual problem is in this area
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.
regards
Abdulla
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