You've got an extra } on the ON JOIN line..