I have 1 table with a list of car makes and an ID.
then I have a list of models with a column for carid that matches the first table.
I was wondering how I can update the model table and replace all the ids with the name from the make table where the makeid matches the other table.
Would something like this work?
update carmodels set carmodels.makeid = carmakes.carname where carmodels.makeid = carmakes.carid