SyntaxFix

[sql] SQL Inner join 2 tables with multiple column conditions and update

You need to do

Update table_xpto
set column_xpto = x.xpto_New
    ,column2 = x.column2New
from table_xpto xpto
   inner join table_xptoNew xptoNew ON xpto.bla = xptoNew.Bla
where <clause where>

If you need a better answer, you can give us more information :)

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to sql-update

• Update some specific field of an entity in android Room • How to perform update operations on columns of type JSONB in Postgres 9.4 • MySQL - UPDATE multiple rows with different values in one query • How to update multiple columns in single update statement in DB2 • Update Multiple Rows in Entity Framework from a list of ids • Update MySQL using HTML Form and PHP • CodeIgniter query: How to move a column value to another column in the same row and save the current time in the original column? • mysql after insert trigger which updates another table's column • Update values from one column in same table to another in SQL Server • I want to use CASE statement to update some records in sql server 2005

Examples related to inner-join

• Trying to use INNER JOIN and GROUP BY SQL with SUM Function, Not Working • Multiple INNER JOIN SQL ACCESS • How to select all rows which have same value in some column • Eliminating duplicate values based on only one column of the table • How can I delete using INNER JOIN with SQL Server? • How to use mysql JOIN without ON condition? • Inner join with 3 tables in mysql • SQL Inner join more than two tables • MySQL INNER JOIN select only one row from second table • Insert using LEFT JOIN and INNER JOIN