>>>Basisverzekering is unique on mijbrpls, but in wiskunde it is not. If I just want one record (the first match) from wiskunde instead of all the matches, how do I achieve this within one query
>>
>>I guess this must be done through a GROUP BY clause.
>>
>>BTW, do they speak Dutch in Morocco?
>
>I think they should speak Arabic and, I presume, French. Their customers can speak whatever they want :).
Well, the table names certainly sound dutch (especially Basisverzekering - meaning basic insurance); of course, the program might be for foreign clients.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)