Self join: TableA ___________ FieldA FieldB FieldC
Assuming Field A is the unique identifier Assuming Field B is the field that is being duplicated, such as email address SELECT a.FieldA, b.FieldA, a.FieldB from TableA a, TableA b WHERE a.FieldB = b.FieldB AND a.FieldA != b.FieldA This will join up the two tables based on FieldB, and will return results where the unique identifier is different on each one. I've used this a lot to clean out duplicate records. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Drew Shuller Sent: Thursday, July 22, 2010 10:15 AM To: [email protected] Subject: Re: Self-Join Joe, Sean, thank you, that is probably the best way. The requirement is to provide backup customer info in case our AD integration fails. My thoughts are to load a snapshot of data gathered from actual help desk records (where there are a lot of duplicates!) every so often into a backup form and than enable some AL's. I'm still wondering how to do the self-join, it may help me with another requirement. Drew ________________________________________________________________________ _______ 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"
