I have this sql update that does not work. The dbo table is ms sql, and tblMembers is local access.
Error: Syntax Error (missing operator)
SET dbo_Customer.secFirstName = tblMembers.secondaryfirstname
INNER JOIN tblMembers
ON dbo_Customer.MembershipID = cstr([tblMembers].[Member_ID])
i figure it has to be simple, but i have fiddled with this for too long.