Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: "Tony Johansson" Newsgroups: comp.databases.ms-sqlserver Subject: How to I select to show only those that have more than one Horse Date: Sun, 8 Feb 2015 00:47:15 +0100 Organization: A noiseless patient Spider Lines: 40 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 8bit Injection-Date: Sat, 7 Feb 2015 23:47:00 +0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="8fdc2b5af81c338deb7045fc6c39b0e2"; logging-data="24832"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+zorCjXpx6CHkfdQiFHt71" X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463 X-Newsreader: Microsoft Windows Mail 6.0.6002.18197 Cancel-Lock: sha1:soyzFIutfGW3TfukXTBCbOFTUVg= X-Priority: 3 X-MSMail-Priority: Normal Xref: csiph.com comp.databases.ms-sqlserver:1878 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