From: johansson.andersson@telia.com   
      
   How can I do this in MySQL or using a view. I want a more standard solution   
   that works in more db then just SQL Server.   
      
   //Tony   
      
      
   "Erland Sommarskog"  skrev i meddelandet   
   news:XnsA43B778BA7558Yazorman@127.0.0.1...   
   > 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)