Hi, Im trying to make a query to update a table i just added an extra column too however I'm getting an error:
this query must be updatable
I think it has something to do with the join in the query. How would i go abotu creating a outer join?
Heres my current query:
UPDATE Applicants INNER JOIN tblStudents_Current ON Applicants.Person_Code=tblStudents_Current.Person_Code
SET Applicants.Forename = tblStudents_Current.Forename
WHERE ((Applicants.Person_Code)=tblStudents_Current.Person_Code);
Help would be muchos appreciated
this query must be updatable
I think it has something to do with the join in the query. How would i go abotu creating a outer join?
Heres my current query:
UPDATE Applicants INNER JOIN tblStudents_Current ON Applicants.Person_Code=tblStudents_Current.Person_Code
SET Applicants.Forename = tblStudents_Current.Forename
WHERE ((Applicants.Person_Code)=tblStudents_Current.Person_Code);
Help would be muchos appreciated
