Join query not displaying all records in one column

[Gumbyu]

Hi experts!

I created a view about 4 months ago that has been working great. The view populates from three tables on joins and displays the records that I want (see below with the selected columns).

However, I added a 'notes' column as a varchar into the pmprojects table and increased the allowable size of txt in the column to 750 characters.

Upon running a query on JUST the pmprojects table, all data appears as it should (even the notes).

However, when the View is run, I only get the notes column populated where both the workorder number and project number is populated. This does not happen with any other field within my join. For instance I can add a date or other txt and recieve the desired result (the correct data is shown).

Would someone mind looking at this to see what I am doing wrong? Please also feel free to give me criticism(s).
Thank you,
Bob

SELECT DISTINCT 
                      TOP 100 PERCENT dbo.DBCostJobsFormatted.JOB_NUMBER  AS [Work Order Number], dbo.pmProjects.WorkOrderNumber AS [Pm Workorder Number],dbo.DBCostJobsFormatted.CUSTOMER_NAME AS [CUSTOMER NAME], dbo.DBCostJobsFormatted.SHIP_TO_1 AS [JOB NAME], dbo.DBCostJobsFormatted.SHIP_TO_3 AS City, RTRIm(dbo.DBCostJobsFormatted.JOB_DESC_1) + ' ' + RTRIM(dbo.DBCostJobsFormatted.JOB_DESC_2) AS [PROJECT DESCRIPTION], dbo.DBCostJobsFormatted.SALESMN_NO AS [SALES #], dbo.DBCostJobsFormatted.Coord AS Coordinator, dbo.DBCostJobsFormatted.JOB_REC_DATE AS [JOB RECD DATE], 
dbo.DBCostJobsFormatted.EST_DUE_DATE AS [EST  DUE DATE], dbo.pmProjects.PermitInHand AS [Permit in Hand], 
dbo.pmProjects.WOintoInstallDept AS [WO into Inst Dept], dbo.pmProjects.FinalInspectionDate AS [Final Inspection], 
dbo.pmProjects.depositrecvd AS [Deposit Recvd], dbo.pmProjects.DateSnttobilling AS [Date Sent to Billing], 
dbo.pmProjects.SignsReceived AS [Signs Recvd], dbo.pmProjects.FabEstShipDate AS [Fab Est Ship Date], 
dbo.pmProjects.ServDate AS [Comp and Service Date], dbo.DBCostJobsFormatted.TOTAL_PRICE AS [Est Price], 
dbo.DBCostJobsFormatted.JOB_CODE AS [Job Code], dbo.pmProjects.AmtSentToBilling AS [Amount Sent to Billing], dbo.pmProjects.UniqueID, 
dbo.pmProjects.OutsideVendor, dbo.pmProjects.PkgSenttoMan, dbo.BRDBCostJob_Codes.JC_Branch, dbo.pmProjects.Notes
FROM         
dbo.BRDBCostJob_Codes RIGHT OUTER JOIN dbo.DBCostJobsFormatted ON dbo.BRDBCostJob_Codes.Job_Code = dbo.DBCostJobsFormatted.JOB_CODE LEFT OUTER JOIN dbo.pmProjects ON dbo.DBCostJobsFormatted.JOB_NUMBER =dbo.pmProjects.WorkOrderNumber