SQL Server – inner join when updating [duplicate]

by 
UPDATE R 
SET R.status="0" 
FROM dbo.ProductReviews AS R
INNER JOIN dbo.products AS P 
       ON R.pid = P.id 
WHERE R.id = '17190' 
  AND P.shopkeeper="89137";

More Related Contents:

  1. What is the best way to create and populate a numbers table?
  2. How do I generate a random number for each row in a T-SQL select?
  3. Auto increment primary key in SQL Server Management Studio 2012
  4. SQL Server Linked Server Example Query
  5. Combine multiple results in a subquery into a single comma-separated value
  6. Infinite loop CTE with OPTION (maxrecursion 0)
  7. SQL Server IN vs. EXISTS Performance
  8. How to drop a table if it exists?
  9. PIVOT in sql 2005
  10. How to run the same query on all the databases on an instance?
  11. Atomic UPSERT in SQL Server 2005
  12. SQL Server truncation and 8192 limitation
  13. Get dates from a week number in T-SQL
  14. What are named pipes?
  15. How to check if a database exists in SQL Server?
  16. BULK INSERT with identity (auto-increment) column
  17. How to update primary key
  18. determining the character set of a table / database?
  19. SQL Server 2008 Row Insert and Update timestamps
  20. Full text search does not work if stop word is included even though stop word list is empty
  21. Should I index a bit field in SQL Server?
  22. Setting up maven dependency for SQL Server
  23. Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
  24. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  25. Escaping single quote in SQL Server
  26. SQL Server 2008 can’t login with newly created user
  27. Update SQL with consecutive numbering
  28. Nested transactions in Sql Server
  29. What is the difference between Cartesian product and cross join?
  30. Count number of records returned by group by

Leave a Comment