Nancy Therrien
asked on
SQL UPDATE Inner Joint
Good Afternoon,
Is there someone that can tell me what is wrong with this command.
Thanks,
UPDATE A_TEMP_R INNER JOIN PROJET INNER JOIN
CORRESPONDANCE ON PROJET.NO_PROJET = CORRESPONDANCE.No_Projet
ON A_TEMP_R.NoOrdreTravail = CORRESPONDANCE.No_Job
SET A_TEMP_R.NoProjet = [CORRESPONDANCE].[No_Proje t]
WHERE (((A_TEMP_R.Journee)>='8/1 /2010'));
Is there someone that can tell me what is wrong with this command.
Thanks,
UPDATE A_TEMP_R INNER JOIN PROJET INNER JOIN
CORRESPONDANCE ON PROJET.NO_PROJET = CORRESPONDANCE.No_Projet
ON A_TEMP_R.NoOrdreTravail = CORRESPONDANCE.No_Job
SET A_TEMP_R.NoProjet = [CORRESPONDANCE].[No_Proje
WHERE (((A_TEMP_R.Journee)>='8/1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER