Bill I am using something like this.
EDIT USING trancpa + WHERE tr_type = 1 AND (CTXT(custnum)+CTXT(tr_date)+ch_code) IN + (SELECT (CTXT(custnum)+CTXT(tr_date)+ch_code), COUNT(*) + FROM tran_daily GROUP BY custnum,tr_date,ch_code + HAVING COUNT (*) > 1) + ORDER BY custnum,tr_date,ch_code CAPTION '*** Are these charges duplicates? ***' Marc From: Bill Niehaus Sent: Monday, July 06, 2009 9:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Duplicate records I am trying to remember the syntax for finding duplicate records in a table based on a specific column. Does someone recall the select command to do such a task? Thanks. Bill Niehaus
