• here's my best guess based on your post's info:

    i'm explicitly aliasing the target table, so it might make it a little clearer:

    UPDATE MyTarget

    SET MyTarget.updtbl_lat = i.infotbl_lat,

    MyTarget.updtbl_long = i.infotbl_long

    FROM UPDTABLE MyTarget

    INNER JOIN INFOTABLE i

    ON MyTarget.updtbl_number = i.infotbl_number

    INNER JOIN DTLTABLE d

    ON d.dtltbl_group = i.infotbl_group

    INNER JOIN DTLTABLE e

    ON e.dtltbl_code = MyTarget.updtbl_code

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!