Lynn Pettis (8/31/2015)
The following should work:
update n SET
[INTERNET-ADDRESS] = 'bsmith@acme.com'
from
SKYWARD.PUB.NAME n
INNER JOIN SKYWARD.PUB.QUDDAT-DATA qd
on n.[NAME-ID] = qd.[QUDDAT-SRC-ID]
WHERE
qd.[QUDTBL-TABLE-ID] = 0 AND
qd.[QUDFLD-FIELD-ID] = 16 AND
qd.[QUDDAT-INT] = 11237;
Thank you for the reply, but it doesn't like that one. It gives the error "Table/View/Synonym not found."