Issue with a join query not diaplaying all records in a notes column

[soklear]

Hi. The issue I am having is the pmproject.notes field does not populate in this view unless both of my join fields are equal. This does not happen with any of the other fields, which populate fine in the query, just the notes field. So, can someone please take a look at this?

Thanks,
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
[code]