Syntax error in script porting SQL2K to Access

[Sydney Lotterby]

(Wrongly posted to the SQL NG - sorry) (SQL2K, Access 2003)

I'm getting an error: "Syntax error (missing operator) in query expression
'xr.ours ..."

Here is the script that works fine in SQL2K

update fx
set fx.ours = xr.ours
from tcaFix_IT fx
inner join tcaXref_IT xr on fx.courts = xr.courts

Any ideas?

Is it related to Alias restrictions in Access?
What other SQL operations doesn't access support?
Is there an equivalent of ISNULL() in access?

tia

 

[spencer4]

Slightly different syntax in Access SQL

update tcaFix_IT fx inner join tcaXref_IT xr

 

[Sydney Lotterby]

Thanks

Do you know of a comprehensive guide detailing the syntax etc differences
between the two?

Is there an equivalent of ISNULL() in access?

 

[Douglas J. Steele]

Sorry: I don't have a reference for a guide to the differences, but the
equivalent of IsNull() is Nz()