Update column with data from another table in SQL

At different point of time we come up with a situation

where we need to update a column in a table from another

 table based on some condition.

So a Basic Syntax for update is:

UPDATE table
SET column1 = expression1,
    column2 = expression2,
    ...
[WHERE conditions];

For us to update based on another table we will be using the

same syntax for update  applying join with another table from

 where we need the data.

UPDATE t1
  SET t1.column_to_update= t2.column_from_update
  FROM Table1 t1
  INNER JOIN Table2 AS t2
  ON t1.common_column= t2.common_column

Comments

Extract Week Start Date and End Date from a given date in c#

Using SqlDataAdapter to fill DataTable in c#

public DataTable List(string sql) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); SqlCommand cmd = new SqlCommand(sql, con); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); try { con.Open(); da.Fill(dt); } finally { con.Close(); } return dt; }

Pivot in Oracle for Dynamic Columns

Pivot in SQL refers to the change of rows into columns based on specific constraints. An example of pivot could be the transpose of matrix. Example: a matrix containing day as 1st row and sales as 2nd row for specific day sun 10 mon 20 tue 30 The transpose of the above matrix would be sun mon tue 10 20 30 This is an example scenario of pivot in sql. Now, Lets get on to the actual tables in database and see how we can use pivot . Starting with a fictional scenario, assume a table which contains two columns DAYS and SALES. CREATE TABLE TEST.DAILY_SALES ( DAYS VARCHAR2(10), SALES NUMBER ) insert into DAILY_SALES('SUN',10); insert into DAILY_SALES('MON',20); insert into DAILY_SALES('TUE',15); insert into DAILY_SALES('WED',25); insert into DAILY_SALES('THU',10); insert into DAILY_SALES('FRI',30); insert into DAILY_SALES('SAT',5); Now when we execute the following select statement se

Lets start with sharing

Search This Blog