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"