I have three tables:

Table: nick_test
name | nickname
JAMES | JAMES
JIM | JIM
JAMES | JIM
JIM | JAMES
JOHN | JOHN

Table: master_test
ln | fn | complete_addr
VANDERSLICE | JIM | 4420 SERRA
VANDERSLICE | JOHN | 123 MAIN

Table: name_src
ln | fn
VANDERSLICE | JAMES
JONES | JASON

I'm selecting records I don't want. I expected only the JIM record from master_test, but the JIM and JOHN records are selected from master_test with this code:

Code:
SELECT master_test.complete_address, master_test.ln, master_test.fn 
                                   FROM master_test
                                   LEFT JOIN name_src
                                                ON master_test.ln = name_src.ln
                                   INNER JOIN nick_test
                                                ON master_test.fn = nick_test.name 
                                                AND master_test.fn = nick_test.nickname
What am I doing wrong?