Join Question

[anunat]

I have two tables: Focus and Comp



I want to join these two tables based on field: DwId

For this example, I made a Comp table that has 3 DwId's not present in the Focus table.

When I run the below statement, I am not getting the 3 records only present in the Comp table in the result.

SELECT Focus.DwId, Focus.PRD_May2012, Focus.PRD_May2012 - Comp.PRD_May2012 AS PRD_DiffMay2012
FROM Focus RIGHT JOIN Comp ON Focus.DwId = Comp.DwId

What am I doing wrong here?

[RayMilhon]

You're doing a right join instead of a left join.