You can create an oracle view using something like this: Assume data looks like this:
REQUEST_ID F2 F3 ___________ __ __ 1 A B 2 B B 3 B B You could create a view that looks something like this: SELECT DISTINCT MIN(REQUEST_ID), F2, F3 FROM ARS_VIEW GROUP BY F2, F3 In theory it should yield REQUEST_ID F2 F3 ___________ __ __ 1 A B 2 B B OR if you needed just F3: SELECT DISTINCT MIN(REQUEST_ID), F3 FROM ARS_VIEW GROUP BY F3 Would yield: REQUEST_ID F3 ___________ __ 1 B You can then create a view form that references the oracle view. From there you can build workflow against it. An easier scenario may be to just run a query, delete the data, reimport the data (assuming the duplicates are no longer needed). Sean -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Drew Shuller Sent: Wednesday, July 21, 2010 3:35 PM To: [email protected] Subject: Self-Join Hello everyone. I've got a form with many many duplicate records in it, at least in one field. Is there a way to use a self-join form that will show only the distinct records? What fields would I use for the join? Or would it use a qualification? I may end up running a DISTINCT query on the db and reloading the form with that data. Thanks in advance! -- Drew Soto Cano Honduras _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
