leftjoin update test case