I have two table. Each has a description column and a code column. I want both table to have the same data for both columns. Currently, table one have description and code populated. Table two has only description populated. Where description matches between the two tables, I wan the same code.
In pusedo SQL code, I need to do an UPDATE SET a.Code = b.code WHERE a.description = b.description.
How do I do this?