I am trying to convert the SQL behind an Access query and use it in a Docmd.RunSQL "" query. I have made several attempts and cannot figure it out. Can someone help me with this? I have two tables linked on the PatientID.
START OF CODE
INSERT INTO tblDiagnosesHold ( Diagnosis, PatientID )
SELECT [Diagnosis] & " (" & [ICD9Code] & ")" AS Expr, [tblPatientsHold].PatientID
FROM tblPatientsHold INNER JOIN tblDimDiagnoses ON [tblPatientsHold].PatientID=tblDimDiagnoses.PatientID;
END OF CODE
Thank you.
START OF CODE
INSERT INTO tblDiagnosesHold ( Diagnosis, PatientID )
SELECT [Diagnosis] & " (" & [ICD9Code] & ")" AS Expr, [tblPatientsHold].PatientID
FROM tblPatientsHold INNER JOIN tblDimDiagnoses ON [tblPatientsHold].PatientID=tblDimDiagnoses.PatientID;
END OF CODE
Thank you.