Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Left outer join and just one match
Message
From
03/09/2007 16:17:46
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
03/09/2007 15:06:15
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01251976
Message ID:
01252032
Views:
21
>>>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform