How to: Remove duplicate TITLES but keep a COUNTRY code

From: leetrainer (leetrainer_at_discussions.microsoft.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 14:17:01 -0700

Hi all

I'm trying to find out how to Retrieve Data from a Single Table and was wondering if someone could help with the following as I cant seem to find the answer to what is probably an easy question for the experts. I'm a Visual FoxPro 6 user and use the following code to almost accomplish what I'm after...

SELECT * FROM mytabletemp INTO TABLE LISTINGS GROUP BY TITLE

This works perfectly and removes any duplicate entries with the same TITLE

My problem (and yes it's been a problem!) is that I have four possible country of ORIGIN codes such EEC - USA - CAN - DOM

When you issue the above command it does remove duplicates but keeps a country of ORIGIN such as EEC.

What I'm trying to do is search out any duplicate TITLES as shown below but keep the USA ones
Example:

ADAMS, BRYAN - BEST OF - EEC
ADAMS, BRYAN - BEST OF - USA
ADAMS, BRYAN - BEST OF - CAN
ADAMS, BRYAN - BEST OF - DOM

I did try:
SELECT * FROM mytabletemp INTO TABLE LISTINGS GROUP BY TITLE WHERE ORIGIN="USA"

but this removes all other ORIGIN such as CAN EEC etc

So, how do I remove three of the above just keeping the USA title?

I would be more than grateful if anyone can suggest the answer
Kindest regards
Lee

Relevant Pages

  • Re: How to: Remove duplicate TITLES but keep a COUNTRY code
    ... > SELECT * FROM mytabletemp INTO TABLE LISTINGS GROUP BY TITLE ... > This works perfectly and removes any duplicate entries with the same TITLE ... country of ORIGIN codes such EEC - USA - CAN - DOM ...
    (microsoft.public.sqlserver.programming)
  • Re: Beyond a shadow of a doubt, and with geometric logic
    ... shadow of a doubt, and with geometric logic, that a duplicate ... key to the wardroom icebox did exist. ... Identify this quote and win an extra bowl of strawberries plus a ... Bryan, meet Henry ...
    (rec.motorcycles)
  • Re: Apprentice katie fired from real job
    ... Adams, you dick. ... Well then I'll carry on doing it, in duplicate or triplicate if need ... I choose to invite you to shove your advice up your arse. ...
    (uk.media.tv.misc)