title: How to achieve inner join using SQLAlchemy?
body: <p>How to achieve inner join using SQLAlchemy ?
  I am trying to make simple chat </p>
  
  <pre><code>class Base(object):
      def __tablename__(self):
          return self.__name__.lower()
  
      id = Column(Integer, primary_key=True)
  
  Base = declarative_base(cls=Base)
  
  class PlayerModel(Base):
      __tablename__ = 'players'
      username = Column(String(30), nullable=False)
      email = Column(String(75), nullable=False)
      password = Column(String(128), nullable=False)
  
  class MessageModel(Base):
      __tablename__ = 'messages'
      player_id = Column(Integer,ForeignKey('chats.id'), nullable=False)
      message = Column(String(2000), nullable=False)
      time = Column(TIMESTAMP, server_default=func.now())
  
      def __repr__(self):
          return "&lt;Message('%s')&gt;" % (self.type)
  </code></pre>
  
  <p>I want to read all messages younger than some date and in result to have list of dictionaries like </p>
  
  <pre><code>[{'username':'x','message':'y','time':'number0'},{'username':'y','message':'z','time':'number1'},
  {'username':'x','message':'zz','time':'number'}]
  </code></pre>
  
  <p>and for that I need inner join. How to make this to work ?</p>