>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

SELECT DISTINCT ... FROM tables WHERE ConditionDistinctFor
UNION ALL
SELECT ... FROM tables WHERE ConditionNotDistinctFor