I have two tables. lets say a car table and a color table. The color table has a single record per car and has a FK to the car table. I am moving the color directly into the car table. I need to migrate existing data. So, the new car table has a color column .
I'd like an UPDATE statement that does all records; that joins the two tables and updates the new color column in the car table based on the existing data in the color table.