From Wikipedia, the free encyclopedia.
Microsoft Visual Basic An example of an combined Update and Join SQL statement is UPDATE project,tasks SET project.projectstatus ='tests' WHERE tasks.duedate< date() and tasks.actualdate =NULL;
It can also be executed programatically
On Error Resume Next
Set mydb = DBEngine.Workspaces(0).OpenDatabase(MDIForm1.currentdatabase)
mydb.Execute "Update project, tasks SET project.projectstatus ='tesyytsgfgf'" & _
"WHERE tasks.duedate< date() and tasks.actualdate =NULL AND project.projectid=tasks.projectid;"
