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.
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.