Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selection problem
Message
 
 
To
29/06/2011 05:02:38
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01516648
Message ID:
01516687
Views:
42
Try
...
FROM mytable mt1
...
  AND NOT EXISTS (SELECT 1 FROM mytable mt2 WHERE mt1.family ref = mt2.individual_ref)
...
>
>I have a list of individuals with a key of individual_ref
>those individuals can be linked to a partner by family_ref
>
>so I would have a row
>
>individual_ref family ref
>58056 174279
>174279 58056
>
>I am selecting a random number of individual but I don't want partners to be selected
>
>How can I do that.
>
>Thanks
>
>Nick
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform