Teradata update join syntax

sql join teradata
oscilatingcretin picture oscilatingcretin · Feb 10, 2012 · Viewed 28.7k times · Source

I've tried a few examples I've seen on the internet, but I can't seem to figure them out. This is a Teradata database.

I have TableA that has CustomerId and DepartmentId.

I have TableB that also CustomerId and DepartmentId.

I know this structure is not practical, but this is a highly non-normalized database that we took over from an offshore development team and we have to work with what we have.

What I want to do is join TableA and TableB on the CustomerId then set the DepartmentId of TableB to what's in TableA. I would greatly appreciate the proper syntax.

Answer

Lenin Raj Rajasekaran picture Lenin Raj Rajasekaran · Feb 10, 2012 
UPDATE A
FROM TableA A, TableB B
SET DepartmentId = B.DepartmentId
WHERE A.CustomerId = B.CustomerId

Related questions

Find which rows have different values for a given column in Teradata SQL

I am trying to compare two addresses from the same ID to see whether they match. For example: Id Adress Code Address 1 1 123 Main 1 2 123 Main 2 1 456 Wall 2 2 456 Wall 3 1 789 Right 3 2 100 Left I'm just trying to figure out whether the address for each ID …

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
SQL update from one Table to another based on a ID match

I have a database with account numbers and card numbers. I match these to a file to update any card numbers to the account number, so that I am only working with account numbers. I created a view linking the …

Read More