Syntax error in script porting SQL2K to Access

  • Thread starter Thread starter Sydney Lotterby
  • Start date Start date
S

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
 
Thanks

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

Is there an equivalent of ISNULL() in access?
 
Sorry: I don't have a reference for a guide to the differences, but the
equivalent of IsNull() is Nz()
 
Back
Top