Post reply

update query help needed ASAP

  • July 19, 2002 at 3:11 pm

    #79072

    I need to update table 1 with table 2 data

    but when I run this it will only update the first record. I know I am missing something very simple.

    Statement:

    UPDATE t

    SET t.EMPLOYER = S.EMPLOYER

    FROM dbo.TABLE1 t,

    dbo.TABLE2 s

    WHERE (t.SEQUENCE = s.SEQUENCE)

  • July 19, 2002 at 5:11 pm

    #433128

    Does sequence have more than one match between tabe1 and table 2. If so then you will only get one record unless another field has a match of some kind.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply