>Thank you for ur help
>
>If I m Issuing 'ORDER BY' Clause then Only Duplicate Records retrieving, Otherwise its working fine(No Duplicate Reords).I tested the same code with SQL Query also,the result is same. If i m issuing 'DISTINCT' Clause, some times the detailed table may contains repeated Datas, this clause will suppress these entries. so how will i solve this situation?
>
Hi Abdulla,
I don't see any dates in the query you posted so I've no idea what you're refering to. Anyway, if 'DISTINCT' clause eliminates a record from resultset than it's a duplicate.
--sb--