I have two tables ; table1 and table 2,

table1 has fields - f1, f2 and f3
table2 has fields - f1, f2 and f4

Code:
    table1                     table2

   f1   f2   f3              f1   f2   f4
   2    3    4               2    3     6
   5    8    7               5    8     7
   11   13   15              11   13   17
I do a Left join for these two tables with this Query:

Code:
select table1.*,table.f4 from table1 left join tester on (table1.f1 = table2.f1 and table1.f2 = table2.f2 and table1.f3 = table2.f4);

Output I am getting is

Code:
f1   f2   f3   f4
2    3    4    null
5    8    7    7
11  13   15   null

But the Output I want is

Code:
f1   f2   f3   f4
2    3    4    6
5    8    7    7
11  13   15   17
Please help me on how this can be got.