• Visually this looks bad, see the pet pevee posts on formatting your code.

    update t1

    set a, b, c, d .f

    from t1 a

    join t2 b on a.poleid=b.poleid

    join t3 c on b.t3id = c.t31d

    where b.poleid =1

    Doesn't this make it easier to read?

    UPDATE t1

    SET a, b, c, d .f -- not sure what you are doing here, you have table references but not setting anything

    FROM t1 a

    INNER JOIN t2 b ON

    a.poleid=b.poleid

    INNER JOIN t3 c ON

    b.t3id = c.t31d

    WHERE b.poleid = 1

    ;

    Visually I would always have the table I am updating as the first table(t1). Your other joins shouldn't matter, someone will correct me if I'm wrong. But I think your WHERE statement will limit the data the same no matter what order you put the other two in.

    I hope this is what you are trying to ask about, it still isn't clear.

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.