/SQL/Update join

Update join

How to add where command in update comand with joins

UPDATE A
SET foo = B.bar
FROM TableA A
JOIN TableB B
    ON A.col1 = B.colx
WHERE ...

2

Source: stackoverflow.com

Update from select join

UPDATE t1
SET t1.COL1 = t2.COL1, t1.COL2 = t2.COL2
FROM MY_TABLE AS t1
JOIN MY_OTHER_TABLE AS t2 ON t1.COLID = t2.ID
WHERE t1.COL3 = 'OK';

1

Update join

//mysql
UPDATE store_fars
        INNER JOIN
   fake ON store_fars.id = fake.id
SET 
    fake.id = store_fars.id

0

Similar codes

0 vote331 views1 answer
Foreign key type uniqu mysql
SQL
1 vote320 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote310 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote368 views1 answer
Alternative for LIMIT sql
SQL
1 vote373 views1 answer
Sql select row with max date
SQL
0 vote324 views1 answer
Frename oracle
SQL
1 vote313 views1 answer
Postgres convert exisiting column to text
SQL
0 vote303 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote303 views2 answers
Update all linkedserver tables with openquery on db
SQL
10 votes327 views6 answers
Sql between
SQL

Share