Re: Question

sangram.thorat_at_gmail.com wrote:
> 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.

If that is the case you have a major problem:

SQL> SELECT count(*)

   2 FROM gv$reserved_words
   3 WHERE KEYWORD IN ('ID', 'DATE', 'AMOUNT', 'EVENT');    COUNT(*)

          2

SQL>
> 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.

I do not understand this statement. I could certainly make a guess but this really begs for a far better description.

> How do I return both the rows i.e having code CODE1 & CODE2?

Look at the SQL statement I used above: It is one way.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org