ms access - SQL Help : Update a field -


i have 2 tables course , course1 both tables have fields called name , id. table course's id field null. need update course table's id field id of course1, both tables related name field.

i using access.

thanks

prady

update [course 1] inner join [course] on course.name = [course 1].name set [course 1].id = [course].id; 

Comments

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

c++ - How to modify context menu of internet explorer using IDocHostUIHandler::ShowContextMenu? -

c# - Asterisk click to call -