update the test data for joining sql
add data and modify the left outer join to left join