Hi,

I want to do a select statement in one table.

The table has two columns:

Citycode, TeamCode

The citycodes may have multiple team codes, and the team code may be the same as the citycode or not.

I want to find the citycodes that have more than one teamcode, and one of the codes is the same as the citycode.