General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi:
I have a table and that table contains duplicate records. I want to copy all the duplicate records to a temp. file.
SELECT Phon0701.ani, Phon0701.billdate, Phon0701.duedate,;
Phon0701.totlocchrg, Phon0701.entrydate, Phon0701.entryby;
FROM phon0701;
WHERE Phon0701.vendor = '12182' and deleted() = .F.;
ORDER BY Phon0701.ani;
InTo cursor CmnthlyRpt
How can I copy dup. rec. to a temp file? I try using set order to anii, but this did not work.
Thanks
Next
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