Try to break down your problems into simple steps, verifying along the way what works and what doesn't, then you'll find where the problem lies.
In this case, try a simple sql query and see if that works, before worrying about the join.
Once the fill works, then you can worry about the SQL.

And it's easier to play with SQL in Management Studio first, IMHO