I have a data set as follows
id State Street City Full Name Dept 908 Nevada 0 Becker Avenue Reno Gregory West PLAN 183 Nebraska 0 Cascade Plaza Omaha Gregory Grant PLAN 538 Oklahoma 0 Dahle Pass Tulsa Shawn Lawrence PLAN 246 Illinois 0 Erie Alley Chicago Shawn Lawrence PLAN 9008 Nevada 0 Becker Avenue Reno Gregory West IT 1893 Nebraska 0 Cascade Plaza Omaha Phyllis Adsit IT 1893 Nebraska 0 Cascade Plaza Omaha Phyllis Adsit IT 5338 Oklahoma 0 Dahle Pass Oklahoma City Shan Larance ITI want to match on Full Name, only those records with DEPT = "PLAN" with records with DEPT = "IT". In other words, records with DEPT = "PLAN" should NOT be matched with themselves and records with DEPT = "IT" should not be matched with themselves. Currently all the data resides in one table.
So in my result set will not have the following
My result set should have the following
Any help in this matter is greatly appreciated.