Can you please make the requirement a little bit more explicit?

Regards
AM

-----Original Message-----
From: DBA
[mailto:oracledba-ezmlmshield-x47869133.[Email address protected]
Sent: sexta-feira, 8 de Julho de 2005 12:05
To: LazyDBA Discussion
Subject: Please Help in query.

Dear DBAs

My requirement is :

I have a table with 2 column :

CAROENQUIRYID PARTICIPANTMAPPINGID
============= ====================
66894942 65438974
66894942 65438977
66894942 65493088
66894942 65583883

66894973 65438974
66894973 65438977
66894973 66104270
66894973 66104271


Now i want result :

CAROENQUIRYID PARTICIPANTMAPPINGID
============= ====================
66894942 65438974
66894942 65438977

66894973 65438974
66894973 65438977

Meanse all the caroenquiryid and participantmapping id which is same for
all the enqiry.

Thanks & Regards
Umesh


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page