Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59

    Unanswered:

    Im not sure you can do what you want in one pass, you may need to do two queries and then filter out any cities which have been matched against state names (and found missing) and vice versa

    this should get you somewhere near wear you want
    "SELECT City_Merge.City, City_Merge.State
    FROM City_Merge LEFT JOIN Categories ON City_Merge.City = Categories.Name
    WHERE Categories.Name Is Null;"

    ..it was created in MS Access
    so to get the other match try

    "SELECT City_Merge.City, City_Merge.State
    FROM City_Merge LEFT JOIN Categories ON City_Merge.State = Categories.Name
    WHERE Categories.Name Is Null;"
    I'd rather be riding on the Tiger 800 or the Norton

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Im not sure you can do what you want in one pass, you may need to do two queries and then filter out any cities which have been matched against state names (and found missing) and vice versa

    this should get you somewhere near wear you want
    "SELECT City_Merge.City, City_Merge.State
    FROM City_Merge LEFT JOIN Categories ON City_Merge.City = Categories.Name
    WHERE Categories.Name Is Null;"

    you will need to extend this to check the states match... should be able to do that using a sub select.. that way round you will filter out say cities in different states with the same name

    Mind you, I think you physical desin is a bit suspect.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •