Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2012
    Posts
    1

    Unanswered: sql comparison between two rows

    Hello

    I need some help with a query i'm trying to write but althogh it works on sql server, the query doesn't work in sql access.. so i would appricate your help.

    my table is 300 rows and it looks like that:

    ID Name City ZipCode Empty
    1 Ben Chicago 4321
    2 Jerry New York 4321
    3 Jerry New York 4321

    the ID is the key.
    I wish that when a row is similar to another row in columns Name,City and Zip (all of them) so one of them, doesn't matter which, will update the empty column to certain value.

    for example, the result of this query shuold be

    ID Name City ZipCode Empty
    1 Ben Chicago 4321
    2 Jerry New York 4321 value
    3 Jerry New York 4321

    Thanks a lot!!

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Which query do you use on sql server?
    Have a nice day!

Posting Permissions

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