David Smith

David Smith

  • NA
  • 2k
  • 0

SQL UPDATE HELP

Feb 22 2013 11:57 AM
I am getting a No required error on the sql below, can someone assist me.


SQL:

UPDATE tblContactSchedule INNER JOIN tmpContactSchedule ON tblContactSchedule.DayID = tmpContactSchedule.DayID
SET tmpContactSchedule.Morning = [tblContactSchedule].[Morning], tmpContactSchedule.Afternoon = [tblContactSchedule].[Afternoon], tmpContactSchedule.Evening = [tblContactSchedule].[Evening], tmpContactSchedule.TimeFrom = [tblContactSchedule].[TimeFrom], tmpContactSchedule.TimeTo = [tblContactSchedule].[TimeTo], tmpContactSchedule.Comment = [tblContactSchedule].[comment],tmpContactSchedule.sysCreateBy = [tblContactSchedule].[sysCreateBy],tmpContactSchedule.sysCreateDate = [tblContactSchedule].[sysCreateDate], tmpContactSchedule.sysUpdateBy = [tblContactSchedule].[sysUpdateBy],tmpContactSchedule.sysUpdateDate = [tblContactSchedule].[sysUpdateDate]
WHERE tblContactSchedule.ContactID =?

Answers (2)