I have attached a Db that has been severely cut back. The data file is around a gig of data and it contains Geo spatial data for the U.S. States and outlying islands.
The table has columns that I use for a level of grouping (State Numeric, Country Numeric, Feature Name). At this level of grouping, I have duplicate data across rows.
By adding Feature Class to the grouping, I can prioritize by the type of class, which row I want to select.
There are two queries that have specific examples where I need to choose between two rows of data.
Although there are 64 potential Feature Classes, I have reduced them to a prioritized list (Military, Populated Place, Civil, Island, and Census) in that order.
For Example 1 Query, I need to make sure that the Selected Row is for the Populated Place instead of Island.
For Example 2 query, I need to make sure that the selected row is for the Military instead of Populated Place.
If I was using VBA, I could use a Select Statement and just set each Case to the priority and then move to the next.
I am not sure how to do it in SQL. I do know that I will need to allow prioritization to at least 6 prioritization of Feature Classes.
I realize this is confusing and I hope the database with the written information makes sense.
Thanks,
Wayne