Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Selection problem
Message
 
 
À
29/06/2011 05:02:38
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01516648
Message ID:
01516687
Vues:
43
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform