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
Post a Comment