mySQL statement not updating table!!

[Ran]

Hello,
Please see my statement below and please help with me with any corrections needed to help me update one query that has 3 fields with data in it, that I want 2 fields to update my master table with insurance data by a relationship I have between 2 tables for one field called "S ins" thanks in advance!

UPDATE updatefrom [Combined SFP], updateto [Copy Of HIM RAW DATA]
INNER JOIN [Combined SFP] ON [Copy Of HIM RAW DATA].[S ins] = [Combined SFP].[S ins]
SET [Copy Of HIM RAW DATA].[FC Groups] = [Combined SFP].[FC Groups] AND [Copy Of HIM RAW DATA].[Payor Dtls] = [Combined SFP].[Payor Details]
WHERE [Copy Of HIM RAW DATA].[FC Groups] ="MCL,MCL,MCL,MCL,COM,MCL,MCL,MCL,MCL,MCL,MCL,COM, COM,COM,COM,COM,COM,COM,MCL,MCL,MCL,MCL,MCL,MCL,ER ROR,COM,COM,COM,COM,COM,COM,COM,MCL,COM,MCL,MCR,CO M,MCL,MCL,MCL,COM,COM,MCL,MCL,MCR,MCR,MCR,MCR,MCR, MCR,MCR,ERROR,ERROR,MCL,MCL,MCL,MCL, COM,COM,MCL,MCAL,MCL,MCL,COM,COM,MCR,COM,COM,COM,M CL,MCL,COM,COM,MCL,MCL,MCL,MCL,MCL"
AND [Copy Of HIM RAW DATA].[Payor Dtls] = "VHP OP/MPC COMM CLINICS,VHP OPD/MPC VMC PCP,SCC SHERIFF DEPT,SCC PAROLEES,ANTHEM BLUE CROSS,PHYSICIANS MED GRP MCMC,CENTRAL CALIFORNIA ALLIANCE HEALTH,BX MCMC,SANTA CLARA FAMILY HEALTH PLN,SANTA CLARA FAMILY HEALTH PLN,SCFHP/VHP STAT-INPT ONLY,BLUE CROSS PRUDENT BUYER,BLUE CROSS PRUDENT BUYER,HEALTH NET,KAISER/OAKLAND,PHYSICIANS MEDICAL GROUP,BLUE CROSS PRUDENT BUYER,BLUE SHIELD,SCC JUV PROB DEPT,MEDI-CAL OP RESTRICTED,MEDI-CAL PENDING NT1,MCAL DDE PENDING,MCAL PEND AT T1,CCS - PROF FEE,CASE Check Digit,AETNA,CIGNA,KAISER/OAKLAND,AUTO INS COVER,X,LABORERS H & W,UNITED HEALTHCARE,APD,BLUE CROSS AIM,RESTRICTED MEDI-CAL,HMO MEDICARE,SANTA CLARA COUNTY IPA (SCCIPA),MEDI-CAL MANAGED CARE,SANTA CLARA FAMILY HEALTH PLAN,BX MCMC,HEALTH NET,PACIFICARE/SR,HEALTHY FAMILIES,HEALTHY KIDS-NETWORK II,J1 MAC-PALMETTO GBA,J1 MAC-PALMETTO GBA,J1 MAC-PALMETTO GBA,J1 MAC-PALMETTO GBA,J1 MAC-PALMETTO GBA,J1 MAC-PALMETTO GBA,J1 MAC-PALMETTO GBA,CASE-Not Found,NO INS- IN SIG CASE IN SIGNATURE,CCS,CCS PENDING,COVERAGE INITIATIVE,FIN CLASS U/Z,VALLEY HEALTH PLAN,X,SCFHP PREMIER CARE,SANTA CLARA FAMILY HEALTH PLAN,MEDI-CAL HMO/PHP,MEDI-CAL EDS-PROF FEE,ONE HEALTH,CHAMPUS/WEST REGION CLAIMS,KAISER SENIOR,FPACT,SC CTY WORKMAN'S COMP,STATE BRD CTRL VICTIM CRM PRG,HEALTHY WORKERS IP,MCL Pending,SJMG,Secure Horizons,CCS PENDING,MEDI-CAL-BAP,MEDI-CAL S.O.C.,APD HEALTHY WORKERS,SCFHP/VHP STAT-INPT ONLY"

[TheShabz]

Without checking your WHERE clause, I do notice that your UPDATE syntax is off. Proper syntax is:
UPDATE [TableName] SET [TableName].[FieldName] = 'whatever'
WHERE ...

[Ran]

Thank you all for reply, I resolved my issue by simplifying my SQL statement to test by updating just one record where something equal something. Now my question is can I add the rest of the data above to the statement below I posted??? So I dont have to create another 77 update queries!!!

UPDATE [HRD] SET [HRD].[FC Groups] = "MCL", [HRD].[Payor Dtls] = "VHP OP/MPC COMM CLINICS" WHERE [HRD].[S ins] = "277";

[Ran]

Need above statement to add additional data to "FC Groups and "Payor Dtls" with data below:

S ins = FC Groups = Payor Dtls
278 = MCL = VHP OPD/MPC VMC PCP
A01 = MCL = SCC SHERIFF DEPT
A02 = MCL = SCC PAROLEES
G49 = MCL = PHYSICIANS MED GRP MCMC

and it keeps going on for another 33 "S ins" and "Payor Dtls" as the "FC Groups" 'MCL' equals S ins and Payor Dtls. If there is a way to add additional languange to mySQL statement to have this done without me having to 38 different UPDATE QUERIES?