I have to update a field data from another table from last 6 months data.
Table1
ID
EmployeeID
ProjectID
Table2
ID
EmployeeID
ProjectID
WeekEnding
I have to update the table 1 ProjectID with the values of table 2 ProjectID matching with the respective employeeID and weekending should be the last 6 months.
My Query is:
UPDATE [Table1], Table2 SET [Table1].ProjectID = [Table2].[ProjectID]
WHERE (([Table2].[WeekEnding]>#2/15/2018#) AND (([Table1].EmployeeID)=[Table2].[EmployeeID]));
But I am getting the wrong output.