Having a syntax problem with Update query

[rtcary]

UPDATE Members_20170308


INNER JOIN RI_20170308 ON ([Members_20170308].[First Name] = [RI_20170308].[First Name]) AND ([Members_20170308].[Last Name] = [RI_20170308].[Last Name])
[Members_20170308].[RI]=[RI_20170308].[RI Number]

Tables: Members_20170308 and RI_20170308

Want [Members_20170308].[RI]=[RI_20170308].[RI Number]

JOIN RI_20170308 ON ([Members_20170308].[First Name] = [RI_20170308].[First Name]) AND
([Members_20170308].[Last Name] = [RI_20170308].[Last Name])

Any suggestions greatly appreciated...

Todd

[ranman256]

This is SQL,
If you build this in a query, it won't get the syntax wrong.
(not paste it, build it.)

[rtcary]

The sad thing for me is that I'm helping a friend and my experience is in Oracle and SQL Server so I'll need to figure out how to use the tools to build an UPDATE with SELECT and JOIN query. Thank you.

Todd