gbooth

SQL DISTINCT

Discussion created by gbooth on Jan 15, 2013
Latest reply on Mar 4, 2013 by nliu
I???m working on a project to identify sexual offenders by their alias name(s). When I do a query on an alias name it displays the master name (given name) and location. However an offender with the master name of James may have multiple alias???s like: Jim, Jimmy and Jimmie.  I want to remove the duplicate results and display the master name and location only once. Can I remove the duplicates with a SQL DISTINCT statement? Does anyone have an example of a SQL DISTINCT in a query.where? I???m using ArcGIS 10 Desktop and Server.
Thanks

Outcomes