Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1880
| From | "Tony Johansson" <johansson.andersson@telia.com> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: How to I select to show only those that have more than one Horse |
| Date | 2015-02-08 10:03 +0100 |
| Organization | A noiseless patient Spider |
| Message-ID | <mb78nl$as8$1@dont-email.me> (permalink) |
| References | <mb685k$o80$1@dont-email.me> <mb78g2$a0p$1@dont-email.me> |
"Tony Johansson" <johansson.andersson@telia.com> skrev i meddelandet news:mb78g2$a0p$1@dont-email.me... > > >> One Rider can own many Horses but one Horse can only be owned by one >> Rider. > The Rider Table have these columns SocSecNr, Name, Phone, E-mail, A path > to an image, Description. Primary key is SocSecNr > The Horse have these columns Id, Name, A path to an image, Description Primary key is Id >> 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.SocSecNr >> 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 — Previous in thread | Next in thread | Find similar
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