Lets start with sharing

Microsoft SQL Server is a Relational Database Management System(RDBMS) developed by Microsoft. It is one of the most popular RDBMS. SQL server has evolved from sql 1.0 in 1989  to the latest release of SQL Server 2019 (preview)  to become one of the best enterprise level database server's. SQL server is released with different editions. Express: Free to use entry level database which can use 1 core cpu, 1 GB ram and have maximum size of 10GB. Compact : Free embedded database for mobile app development and can have maximum size of 4GB. Enterprise : Full featured top end edition. Standard : Have less features than enterprise. WorkGroup: suitable for a company to use among the group. Developer: Same features like enterprise but is  licensed  to one user only. Web: Specially targeted for web application There are some other editions like Datacenter, Enterprise evaluation and Business Intelligence. These all editions are not available on all version of SQL Server. No

  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