Below is the code
trying to append rows from bc_stage_genomics into bc_genomics_masterlist but when I hit a run it says you are about to append 0 rows... any help after hours of trying to figure out why??
UPDATE bc_genomics_masterlist INNER JOIN stage_bc_genomics ON bc_genomics_masterlist.InHouse_PatientID = stage_bc_genomics.InHouse_PatientID SET bc_genomics_masterlist.AbsLog_AuditLogDate = [stage_bc_genomics].AbsLog_AuditLogDate, bc_genomics_masterlist.InHouse_PatientID = [stage_bc_genomics].InHouse_PatientID, bc_genomics_masterlist.CaseconID = [stage_bc_genomics].CaseconID, bc_genomics_masterlist.Case_Control_Description = [stage_bc_genomics].Case_Control_Description, bc_genomics_masterlist.Registry = [stage_bc_genomics].Registry, bc_genomics_masterlist.DX_Year = [stage_bc_genomics].DX_Year, bc_genomics_masterlist.Current_Tissue_Age_Yrs = [stage_bc_genomics].Current_Tissue_Age_Yrs, bc_genomics_masterlist.Destruction_Risk = [stage_bc_genomics].Destruction_Risk, bc_genomics_masterlist.Formal_Request = [stage_bc_genomics].Formal_Request, bc_genomics_masterlist.Need_HER2 = [stage_bc_genomics].Need_HER2, bc_genomics_masterlist.Specimen_Types = [stage_bc_genomics].Specimen_Types, bc_genomics_masterlist.Tumor_Specimen_Notes = [stage_bc_genomics].Tumor_Specimen_Notes, bc_genomics_masterlist.Prev_Assessed = [stage_bc_genomics].Prev_Assessed, bc_genomics_masterlist.PathReport_Available = [stage_bc_genomics].PathReport_Available, bc_genomics_masterlist.PathReport_Notes = [stage_bc_genomics].PathReport_Notes, bc_genomics_masterlist.Tissue_Availability = [stage_bc_genomics].Tissue_Availability, bc_genomics_masterlist.Tissue_Notes = [stage_bc_genomics].Tissue_Notes, bc_genomics_masterlist.Neoadj_Therapy = [stage_bc_genomics].Neoadj_Therapy, bc_genomics_masterlist.Neoadj_Notes = [stage_bc_genomics].Neoadj_Notes, bc_genomics_masterlist.Tissue_Destruction_Status = [stage_bc_genomics].Tissue_Destruction_Status, bc_genomics_masterlist.Date_Planned_Tissue_Destruc tion = [stage_bc_genomics].Date_Planned_Tissue_Destruction, bc_genomics_masterlist.Tissue_Destruction_Notes = [stage_bc_genomics].Tissue_Destruction_Notes, bc_genomics_masterlist.Abstraction_Complete = [stage_bc_genomics].Abstraction_Complete, bc_genomics_masterlist.Abstraction_Notes = [stage_bc_genomics].Abstraction_Notes, bc_genomics_masterlist.Date_Tissue_Sent = [stage_bc_genomics].Date_Tissue_Sent, bc_genomics_masterlist.Tissue_Acquisition_Notes = [stage_bc_genomics].Tissue_Acquisition_Notes;