Post reply

Unable to Update

  • September 8, 2006 at 8:50 am

    #62271

    I have a simple query that is not cooperating with me:

    UPDATE Tbl_Dates2

    SET lst_upd_ts=Tbl_Dates_Convert.lst_upd_ts

    WHERE (TS=Tbl_Dates_Convert.TS)

    The error I'm getting is: The clomn prefix 'Tbl_Dates_Convert' does not match with a table name or alis name used in the query.

    The tables are all there. Any ideas?

    Thanks...Nali

  • September 8, 2006 at 8:57 am

    #659363

    Hello,

    Where is the "From" clause in your query???

    Thanks


    Lucky

  • September 8, 2006 at 9:05 am

    #659368

    Not tested, but something like this should work.

    John

    UPDATE t

    SET t.lst_upd_ts = c.lst_upd_ts

    FROM Tbl_Dates_Convert c JOIN Table_Dates2 t

    ON t.TS = c.TS

  • September 8, 2006 at 9:36 am

    #659375

    Thanks John and Lucky, that worked. Where can I send the checks?

  • September 8, 2006 at 2:01 pm

    #659454

    Oooh - I don't know.  Send it to your favourite good cause.

    Seriously, though - happy to help.

    John

Viewing 5 posts - 1 through 4 (of 4 total)

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