Results 1 to 4 of 4

Thread: Multiple Where

  1. #1
    Join Date
    Jan 2004
    Posts
    45

    Unanswered: Multiple Where

    This Update Works
    -----------------------------------------------------------------
    update sales_ter_email
    set sales_email ="bristaino@yankeeequipment.com"
    and sales_person ="Brendan Ristaino"
    Where city = "arlington"
    and state ="MA"
    -----------------------------------------------------------------
    This one does not
    -----------------------------------------------------------------
    update sales_ter_email
    set sales_email ="bristaino@yankeeequipment.com"
    and sales_person ="Brendan Ristaino"
    Where city = "arlington"
    and city = "ayer"
    and state ="MA"
    ------------------------------------------------------------------

    is what I am trying to do possible?

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    there should be no problems doing the second if the first works properly.
    Do you actually have a row that meets the criteria set out in the second update statement?

  3. #3
    Join Date
    Jan 2004
    Posts
    45
    Yes I have an ayer and an arlington row in the city column. But I just found out that my first is not updating but clearing the data, so no I am back to the beginning, again.

  4. #4
    Join Date
    Jan 2004
    Posts
    45
    got it, no "and" in the set funtion

Posting Permissions

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