Generates the JOIN sql for the join tables and join condition

        :rtype: str
        :return: the JOIN sql for the join tables and join condition

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())