<SYSTEM_TASK:>
Solve the following problem using Python, implementing the functions described below, one line at a time
<END_TASK>
<USER_TASK:>
Description:
 def get_sql(self):
 """ Generates the JOIN sql for the join tables and join condition :rtype: str :return: the JOIN sql for the join tables and join condition """

        return '{0} {1} ON {2}'.format(self.join_type, self.right_table.get_sql(), self.get_condition())