From: esquel@sommarskog.se   
      
   Tony Johansson (johansson.andersson@telia.com) writes:   
   > One Rider can own many Horses but one Horse can only be owned by one   
   > Rider.   
   > This query list all the relation between a Rider and a Horse.   
   >   
   > select Rider.Namn, Horse.Namn as Horsename   
   > from Rider, Horse   
   > where Horse.RiderID= Rider.SocNr   
   > order by Rider.Namn   
   >   
   > Name                      Horsename   
   >  Adeline Falk           Vilja F   
   > Anna Westman         Solidago   
   > Anna Westman         early morning grey   
   > Corola Häggqvist     Com-on Landlyst   
      
   Corola? Are you trying to avoid trade-mark infringement? :-)   
      
   For instance:   
      
    WITH CTE AS (   
       SELECT R.Name, H.Namn AS Horsname,   
              COUNT(*) OVER(PARTITION BY R.SocNr) AS cnt   
       FROM   Rider R   
       JOIN   Horse H ON H.RiderID = R.SocNr   
   )   
   SELECT Name, Horsename   
   FROM   CTE   
   WHERE  cnt >= 2   
      
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)