docstr: Query.join
docstr_tok: ["Query.join"]
code: def test_join(self):
      """Query.join"""
  
      User, Address = self.classes.User, self.classes.Address
      Order = self.classes.Order
  
      session = fixture_session()
      q = (
          session.query(User)
          .outerjoin(User.orders)
          .outerjoin(Order.addresses)
          .filter(Address.id == 1)
      )
      eq_([User(id=7)], q.all())
  
imports: import sqlalchemy
  from sqlalchemy import ForeignKey
  from sqlalchemy import func
  from sqlalchemy import Integer
  from sqlalchemy import testing
  from sqlalchemy.orm import relationship
  from sqlalchemy.testing import config
  from sqlalchemy.testing import eq_
  from sqlalchemy.testing import fixtures
  from sqlalchemy.testing.fixtures import fixture_session
  from sqlalchemy.testing.provision import normalize_sequence
  from sqlalchemy.testing.schema import Column
  from sqlalchemy.testing.schema import Table
  from test.orm import _fixtures
label_desc: Use image node_id 2 for calling the RelationshipsTest obj's underlying member method code with example usage: obj.test_join() without return types