I have to get information out of 3 tables:

I am showing you the string which i am using at the moment:
With this i get a list of cities which contain description in Dutch

[code]

SELECT 
tabel2.main_id, 
tabel3.stad_naam, 
COUNT(*) AS count 
FROM 
tabel1, 
tabel2, 
tabel3 
WHERE 
tabel2.main_id=tabel1.main_id AND 
tabel2.omschrijving_id='1' AND 
tabel2.land='fr' AND 
tabel1.stad_id=tabel3.stad_id AND 
tabel3.taal='nl' 
GROUP BY stad_id 
ORDER BY stad_naam ASC

[/code]

But! the name of the cities should be desplayed Dutch as well ...if present...
(So for Paris it will be Parijs)

Now...
table3 containts all the cities with:
- language code
- name of the city (in multiple language IF present!)
- city_id

A city in an other language has the SAME city_id
but not all cities are tranlated in Dutch
For these fields i put in NULL

How can i using IF ELSE or CASE 
put this in the Query show above?

And can i COUNT the total row at the same time?

Regards!

look up the keyword 'coalesce'.