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? -

aspxgridview - Devexpress grid - header filter does not work if column is initially hidden -

c# - How to execute a particular part of code asynchronously in a class -