Code: Select all
UPDATE table SET column = Expression [, ...] [WHERE Expression];
Code: Select all
UPDATE TBLA
SET TXT = TBLB.TXT
FROM TBL2
WHERE TBLA.ID = TBLB.ID
Code: Select all
UPDATE table SET column = Expression [, ...] [WHERE Expression];
Code: Select all
UPDATE TBLA
SET TXT = TBLB.TXT
FROM TBL2
WHERE TBLA.ID = TBLB.ID
Code: Select all
UPDATE TBLA
SET TXT = (SELECT TXT FROM TBLB WHERE TBLA.ID = TBLB.ID )
WHERE EXISTS (SELECT * FROM TBLB WHERE TBLA.ID = TBLB.ID )
Code: Select all
UPDATE TBLA
SET
TXT = (SELECT TXT FROM TBLB WHERE TBLA.ID = TBLB.ID ),
X = (SELECT X FROM TBLB WHERE TBLA.ID = TBLB.ID ),
Y = (SELECT Y FROM TBLB WHERE TBLA.ID = TBLB.ID ),
Z = (SELECT Z FROM TBLB WHERE TBLA.ID = TBLB.ID )
WHERE EXISTS (SELECT TXT FROM TBLB WHERE TBLA.ID = TBLB.ID )
Code: Select all
DELETE FROM TBLA
WHERE ID IN (SELECT ID FROM TBLB)
Code: Select all
INSERT INTO TBLA
SELECT * FROM TBLB
Code: Select all
WHERE NOT ID IN (SELECT ID FROM TBLA)