Update SQL statement only if two values match in another table

user3498953 Published at Dev

user3498953

I have been searching for this scenario that has come across my desk, I have been searching reference sites but haven't had luck creating the correct SQL statement to complete this task.

Here is the PSEUDO code for the scenario.

UPDATE TABLE1
SET TABLE1.ID = TABLE1.From_ID,
    TABLE1.VALUE = 'ALL'
WHERE TABLE1.From_ID = TABLE2.ID
  AND TABLE2.NAME = 'TEST'

Basically I need to update two columns in TABLE1 only if the id from TABLE1 matches the ID's in the TABLE2 and the description column in TABLE2 equals to a string value the caveat is that TABL1 columns can't be change only if there is a correlation between the ID's from TABLE1 and TABLE2 and in TABLE2 that ID correlates to description column for a specific string value. Below is table structure and end result I'm trying to get too.

TABLE1:

FIELD_ID    CONDITIONAL_VALUE   FROM_FIELDID
--------------------------------------------   
   1        TEST                   3
   7        TEST                   4
   5        ANY                    7

TABLE2:

FIELD_ID   Description
----------------------------------------------
   3       BLUE
   4       BLUE
   7       RED

dpw

In Transact-SQL (SQL Server's dialect of SQL), you need a FROM clause in your SQL if you specify more than the table you're trying to update.

update TABLE1.ID set TABLE1.ID = TABLE1.From_ID , TABLE1.VALUE = 'ALL' from TABLE1, TABLE2 where TABLE1.From_ID = TABLE2.ID AND TABLE2.NAME = ''TEST

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-7

Comments

0 comments

From Dev

Related Related

Article

Update SQL statement only if two values match in another table

Update SQL statement only if two values match in another table

MySQL update statement match only the first row

SQL statement to combine both fields in one table that match the id element in another table

Update sql table daily with values from another table

Update one table based on values in another table using case statement (MYSQL)

UPDATE table with two different values

How to write sql statement to newly added column with another table values?

Update two columns values in a table based on another column value in different table

How to get an Update Statement to change the values depending on entries from another Table

SQL - Update table values from values in another table

SQL set operation to update table based on values on another table

sql update table - statement not working

SQL AVG statement another table

Matching two values in a table to another value in a table sql

SQL: Lookup values in another table and update them

Need an update statement that multiplies two column values from diffrent table in mysql

UPDATE one SQL table based on equality of two columns with two columns from another table

Return best values of two SQL tables along with the values from table 1 that has no match in table2

SQL update statement for two tables

MySQL update table only with the highest values of another table

update value from a table if from other two table values match

Update statement with select to another table

Using a Case statement to update another table

SQL update values in one table to match values of another table in Oracle SQL Developer

update values in a string to another table

Matching two values in a table to another value in a table sql

SQL Comparing Two Columns in same table and update in another table

SQL update statement based unique value in another table

MS Access: Update the values in a table to match the ID fields of another table

Update table with values of another table