1) Why did you select 9001 rather than 9000 for new rows 4,5 and 6 in desired-results?

2) In desired-results rows 1-3 and 7-10, why aren't you returning values from TableB.FieldC? As it stands, it looks like this column contains mixed data - not good.