Database

CREATE TABLE Test1 (
Column1 varchar(50)
);

INSERT INTO Test1 (Column1)
VALUES ('ABC');

CREATE TABLE Test2 (
Column2 varchar(50)
);

UPDATE Test1
SET Test1.Column1 = Test2.Column2
FROM Test2

UPDATE Test1
SET Test1.Column1 = a.Column2
FROM Test2 a
INNER JOIN Test2 b
ON a.Column2 = b.Column2

UPDATE MyTable
SET p.Column1 = (SELECT pm.Column1
                 FROM Property p
                 inner join Address a
                 on p.PropertyRef = a.PropertyRef
                 inner join remotedb.PropertyMaster pm
                 on pm.PropertyRef = p.PropertyRef)

Ashfield wrote:

This is the 3rd time you have asked the question, the answer is NOT going to change!!!!!

INSERT INTO commentdetail
(commentDetailID, commentID, commentType, locator1, locator2)
VALUES (?commentDetailID, ?commentID, ?commentType, ?locator1, ?locator2)

Header||
xx|yy|zz
aa|bb|cc
Footer||