EDS inner join returns no data, left join does

The query which returns 0 rows is below, it's the "inner join Entity_Model.RefData.Persons p" where the problem seems to centre. select p.NtSystemLogin as book_trader_id, hierarchy.book_code,hierarchy.book_description,hierarchy.trader_portfolio_id,hierarchy.division_id, hierarchy.business_area_id,hierarchy.desk_id,hierarchy.desk_portfolio_id,hierarchy.risk_portfolio_id,hierarchy.product_portfolio_id, p.Name as book_trader_desc, sourceBooks.alternatebookid from buchierarchy hierarchy inner join Entity_Model.Ledger.LedgerBooks books on hierarchy.book_code = books.book_code inner join Entity_Model.RefData.SourceBooks sourceBooks on sourceBooks.ledgerBookId = books.book_code inner join Entity_Model.RefData.Persons p on books.book_trader_id = p.personId where books.BOOK_BUSINESS_DATE = '2011-09-22' and sourceBooks.sourcesystemid IN ('GDSLDN','GDSHKG') and books.book_active_indicator = 'A' and sourceBooks.activeindicator = 'A' and hierarchy.division_id = 'GBM' and hierarchy.business_area_id = 'FMRates' and hierarchy.desk_id = 'DelLdnTrd' and hierarchy.desk_portfolio_id = 'FWD' and sourcebooks.alternatebookid = 'SWAPGDSLDN2806' Changing that join to "left join Entity_Model.RefData.Persons p" returns the 1 row we expect. book_trader_id Another way to get the query to return this one row is to put a makedep hint on the ledgerbooks table (inner join on Persons). Obviously we wouldn't expect these kind of hints to influence the results. (Modelset attached)