Outer Join not giving expected results.
Posted on 2006-04-27
I have a query to compare trades between months:
mvp.MarketValue, pri.MarketValue, pri.COBDate
FROM tblArc_MarketValuePositions mvp LEFT OUTER JOIN tblArc_MarketValuePositions pri ON
mvp.Position_ID = pri.Position_ID
WHERE mvp.COBDate = @COB_Cur AND
pri.COBDate = @COB_Pri AND
mvp.CurrencyType_Identifier = 'USD'
I'm expecting 376 mvp records with some null values for the right hand table fields where theres no right hand position ID. What I get is only 292 rows as if I did an inner join. I'm not getting where I'm screwing up here. Any ideas?