Complicated Insert Statement
I have a table called USERS that has a column called Division. The values are actually the Division_id from another table called DIVISIONS. I need to create a column in the USERS table that lists the Division_name, which can also be found in the DIVISION table.
Each Division_name has a Division_id, so the new column's data (Division_name) must equal the Division_id that is already in the USER table.
I'm not sure if this can be done, but I think it needs to be something like this....
INSERT INTO users (sbu)
From Division d, Users u
WHERE u.division_id = d.division_name
I'm really new at SQL so I need some assistnace.