Select .. WHERE lang="nl" or lang="en"

Hi,

I have a table `cities`:
city_id
countrycode
languagecode
name
primary key (city_id, languagecode)

I want fetch all cities with countrycode="fr" and languagecode="nl",
If city_id in languagecode="nl" not exists, I want fetch THIS city in
languagecode="en"


EXAMPLE:
city_id countrycode languagecode name:
1 fr en Paris
2 fr en Bordeaux
1 fr pl Pary¿
2 fr pl (null OR '')

countrycode="fr" and languagecode="pl":
2 fr en Bordeaux
1 fr pl Pary¿


Any ideas?

dag wrote:
> Hi,
>
> I have a table `cities`:
> city_id
> countrycode
> languagecode
> name
> primary key (city_id, languagecode)
>
> I want fetch all cities with countrycode="fr" and languagecode="nl",
> If city_id in languagecode="nl" not exists, I want fetch THIS city in
> languagecode="en"
>
>
> EXAMPLE:
> city_id countrycode languagecode name:
> 1 fr en Paris
> 2 fr en Bordeaux
> 1 fr pl Pary¿
> 2 fr pl (null OR '')
>
> countrycode="fr" and languagecode="pl":
> 2 fr en Bordeaux
> 1 fr pl Pary¿
>
>
> Any ideas?

You said: 'If city_id in languagecode=... not exists, I want fetch THIS city
in
languagecode="en"'

But in the example you have given, the city_id 2 with countrycode = "fr" and
languagecode="pl" DOES exist, and yest you have said that the output should
ignore it!