Groups > comp.databases.ms-sqlserver > #1878

How to I select to show only those that have more than one Horse

From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	How to I select to show only those that have more than one Horse
Date	2015-02-08 00:47 +0100
Organization	A noiseless patient Spider
Message-ID	<mb685k$o80$1@dont-email.me> (permalink)

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

How to I select to show only those that have more than one Horse "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-08 00:47 +0100
  Re: How to I select to show only those that have more than one Horse "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-08 09:58 +0100
    Re: How to I select to show only those that have more than one Horse "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-08 10:03 +0100
  Re: How to I select to show only those that have more than one Horse Erland Sommarskog <esquel@sommarskog.se> - 2015-02-08 11:45 +0100
    Re: How to I select to show only those that have more than one Horse "Tony Johansson" <johansson.andersson@telia.com> - 2015-02-08 12:40 +0100
      Re: How to I select to show only those that have more than one Horse Erland Sommarskog <esquel@sommarskog.se> - 2015-02-08 16:22 +0100
        Re: How to I select to show only those that have more than one Horse rja.carnegie@gmail.com - 2015-02-08 09:27 -0800
  Re: How to I select to show only those that have more than one Horse --CELKO-- <jcelko212@earthlink.net> - 2015-02-08 09:35 -0800
    Re: How to I select to show only those that have more than one Horse Ross Presser <rpresser@gmail.com> - 2015-02-09 21:21 -0800

csiph-web