added 2 test methods for leftJoin