Question

Suppose Table T has following columns (id, date, amount, event & code)

For each record in table T where code is CODE1, compare to this account's other transactions that have source of CODE2 for duplicates - match on id | date | amount | and event.

Create table of data; include CODE1 records in table T AND CODE2 records in table t found to be the duplicate. FIELDS: id, date, amount, event & code.

How do I return both the rows i.e having code CODE1 & CODE2? Received on Sun Aug 20 2006 - 19:05:07 CDT