Help with query - missing operator

[Bobby9779]

I am attempting this query and getting a syntax error missing operator and cannot figure out why!

UPDATE Temp_Allocation
SET a.Service_ID = p.Service_ID
FROM personnel p, temp_Allocation a
WHERE a.Service_ID=p.Service_ID
AND p.Service_No = [Enter Service Number] 
AND [Date] = [Enter Date]
AND Duty_ID LIKE '2';

[Enter Service Number] and [Enter Date] are user inputs.

This query will eventually be used in a php code.

Please help.

 

[Bobby9779]

Oh yeah, sorry, the error is highlighting FROM!

 

[MarkK]

If you want to alias tables in Jet SQL I think you need to use 'As' ...

...
[COLOR="Blue"]FROM[/COLOR] personnel [COLOR="Blue"]As[/COLOR] p, temp_Allocation [COLOR="Blue"]As[/COLOR] a
...

 

[Bobby9779]

Thank you lag. I have tried it both ways and it works without on standard queries. There must be something else I'm missing.