update columns values with column of another table based on condition [duplicate]

by

Something like this should do it : 

UPDATE table1 
   SET table1.Price = table2.price 
   FROM table1  INNER JOIN  table2 ON table1.id = table2.id

You can also try this:

UPDATE table1 
   SET price=(SELECT price FROM table2 WHERE table1.id=table2.id);

More Related Contents:

  1. Stored Procedure with optional “WHERE” parameters
  2. How do I list all the columns in a table?
  3. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  4. Is there a combination of “LIKE” and “IN” in SQL?
  5. SQL – How to store and navigate hierarchies?
  6. Can a foreign key be NULL and/or duplicate?
  7. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  8. Multiplication aggregate operator in SQL
  9. SQL: Repeat a result row multiple times, and number the rows
  10. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  11. MySQL equivalent of DECODE function in Oracle
  12. Deferrable Constraints in SQL Server
  13. Benefits Of Using SQL Ordinal Position Notation?
  14. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  15. Unordered results in SQL
  16. How do I create a table alias in MySQL
  17. Backup SQL Schema Only?
  18. Connecting to Oracle Database using Sql Server Integration Services
  19. Why in SQL NULL can’t match with NULL?
  20. Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?
  21. I need help formatting inner join command in SQL query
  22. Search All Fields In All Tables For A Specific Value (Oracle)
  23. How to get next/previous record in MySQL?
  24. SQL transpose full table
  25. How to Create a real one-to-one relationship in SQL Server
  26. How does GROUP BY work?
  27. How do I start auto increment from a specific point?
  28. How to use a dynamic parameter in a IN clause of a JPA named query?
  29. Perform regex (replace) in an SQL query
  30. Group consecutive rows of same value using time spans

Leave a Comment