Yes, it does.
SELECT  dbo.mdhomadm.Patient_Number, dbo.mdhomadm.Diagnosis9_1, dbo.mdhomadm.Diagnosis9_2, dbo.mdhomadm.Diagnosis9_3, dbo.mdhomadm.Diagnosis9_4, dbo.mdhomadm.Diagnosis9_5,
   dbo.mdhomadm.Diagnosis9_6, dbo.mdhomadm.Diagnosis9_7, dbo.mdhomadm.Diagnosis9_8, dbo.mdhomadm.Diagnosis9_9, dbo.mdicdcde.ICD_Code_Description
FROM  dbo.mdhomadm LEFT OUTER JOIN
   dbo.mdicdcde ON dbo.mdhomadm.Diagnosis9_1 = dbo.mdicdcde.ICD_Code

The problem is...

Can you post a CREATE TABLE script and the INSERT scripts for this?
And maybe fix up your SQL so we can read it?

This should get you started. Since you're new here, I created your table and added some data. If you want a tested answer, you should provide this.
CREATE...

Okay, thanks!  (Finally got the e-mail from my database!... where do they go when they get lost between my computer and gmail?) So I know the code works...
Guess...

I'll have a read. From a quick scan, I'd basically have to use a unique subject and search for that and the recipient's e-mail in the table, and if not...

like this?
CREATE TABLE [dbo].[ProductCodes](
    [F_Product] [char](1) NOT NULL,
    [F_TextCode] [char](7) NOT NULL,
    [F_Phrase] [varchar](5) NOT NULL
);
GO

INSERT INTO ProductCodes VALUES
('A','MANU001','TEST1'),
('A','MANU002','TEST2'), ...

no. my requirement was super simple. Essentially, when an employee is assigned a task/drug protocol/whatever, send him an e-mail advising him of it. I had asked about this maybe pre-Service...

Maybe they're waiting for you to post your plan for them to comment on?

Got context?

Oh, okay. That's what I was wondering. Thanks for the explanation. I was reading the documentation and it wasn't totally clear.

Thanks, Lowell (and everybody). That answers my question.

There query appears to be missing an alias:
SELECT o2a.SOURCE_ID source_id, o2a.VALUE 
FROM CR2Copy..OBJECT_TO_ATTRIBUTE

should be
SELECT o2a.SOURCE_ID source_id, o2a.VALUE 
FROM CR2Copy..OBJECT_TO_ATTRIBUTE AS o2a