Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1880
| Path | csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| 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 | Sun, 8 Feb 2015 10:03:01 +0100 |
| Organization | A noiseless patient Spider |
| Lines | 55 |
| Message-ID | <mb78nl$as8$1@dont-email.me> (permalink) |
| References | <mb685k$o80$1@dont-email.me> <mb78g2$a0p$1@dont-email.me> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; format=flowed; charset="iso-8859-1"; reply-type=response |
| Content-Transfer-Encoding | 8bit |
| Injection-Date | Sun, 8 Feb 2015 09:02:45 +0000 (UTC) |
| Injection-Info | mx02.eternal-september.org; posting-host="8fdc2b5af81c338deb7045fc6c39b0e2"; logging-data="11144"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18Gvfwbyme6ea3g2CqABcmz" |
| X-MimeOLE | Produced By Microsoft MimeOLE V6.0.6002.18463 |
| In-Reply-To | <mb78g2$a0p$1@dont-email.me> |
| X-Newsreader | Microsoft Windows Mail 6.0.6002.18197 |
| Cancel-Lock | sha1:6XLECC8qbh6PBv+zCs0QG9IZTLQ= |
| X-Priority | 3 |
| X-MSMail-Priority | Normal |
| Xref | csiph.com comp.databases.ms-sqlserver:1880 |
Show key headers only | View raw
"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