Update Table With Inner Join

Posted on By David Kittell 
UPDATE table1
SET table1.column1 = table2.column1
	,table1.last_name = table2.last_name
	,table1.first_name = table2.first_name
	,table1.gender = table2.gender
FROM table1
INNER JOIN table2 ON table1.child_column2 = table2.column2
WHERE table1.child_column2 IS NOT NULL;
Originally Posted on September 18, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL SQL

Related Posts

Calculate Age Function

Posted on

Two variations of the function but the purpose is to determine the difference in dates and display the result in one column. IF OBJECT_ID(N’dbo.fnAge’) IS NOT NULL DROP FUNCTION dbo.fnAge GO CREATE FUNCTION [dbo].[fnAge] ( @dayOfBirth DATETIME ,@today DATETIME ) RETURNS VARCHAR(100) AS BEGIN DECLARE @thisYearBirthDay DATETIME DECLARE @years INT…

Read More

Classic ASP Send Email

Posted on

<% Set myMail=CreateObject("CDO.Message") if Request("subject") <> "" then myMail.Subject=Request("subject") else myMail.Subject="<Subject>" end if if Request("from") <> "" then myMail.From=Request("from") else myMail.From="<From Email Address>" end if if Request("To") <> "" then myMail.To=Request("To") else myMail.To="<To Email Address>" end if if Request("Cc") <> "" then myMail.CC=Request("Cc") else myMail.CC="<CC Email Address>" end if myMail.TextBody=…

Read More

VB.NET – Remove Empty Folders

Posted on

‘Remove Empty Folders – Start Public Shared Sub RemoveEmptyFolders(ByVal path As String) Dim directory As New DirectoryInfo(path) For Each subDirectory As DirectoryInfo In directory.GetDirectories() If subDirectory.GetFiles().Length = 0 Then Try subDirectory.Delete() Catch ex As Exception End Try End If Next subDirectory End Sub ‘Remove Empty Folders – Stop Originally Posted…

Read More