Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Left outer join and just one match
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01251976
Message ID:
01253196
Views:
28
>>Try
>>Select * from basisverzekering ;
>>	left outer join wiskunde on basisverzekering.mijbrpls = wiskunde.mijbrpls ;
>>		AND wiskunde.vlgnr_mut = ( SELECT MIN(vlgnr_mut) FROM wiskunde w2 ;
>>						WHERE w2.mijbrpls = wiskunde.mijbrpls)
>
>
>
>>
>Thanks that seems to work
>

You're welcome
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform