The Dixie Flatline (8/23/2016)
Pssst... "MIAMI"Also, I'm missing something.
Why not just select where [Statename] <> 'ALL' ?
Because he wants the cities where there's no row for that city with the StateName ALL. A <>'ALL' will return Austin and DodgeCity, which shouldn't be returned.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability