From: johansson.andersson@telia.com   
      
   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   
   Emil Olsson             Thea   
   Emil Olsson             Innocentia   
   Fantomen                 Fighter   
   Natalie Adelborg     Femerick   
   Sanna Johansson     Karavella   
   Sara Ignberg          Trisdan   
   Stålmannan             Marshall   
   Stålmannan             Oliver   
   Sven Tumba             Rasmus   
   Sven Tumba             Lukan   
      
   How do I change this query if I only want to list those that have more then   
   one horse.   
   So the result from the query should be this.   
      
   So the result would be   
   Anna Westman         Solidago   
   Anna Westman         early morning grey   
   Emil Olsson             Thea   
   Emil Olsson             Innocentia   
   Stålmannan             Marshall   
   Stålmannan             Oliver   
   Sven Tumba             Rasmus   
   Sven Tumba             Lukan   
      
   //Tony   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)