Eg : 1
query = Session.query(Person) query = query.join(Address, Address.person_id == Person.id) query = query.filter(Address.city == "abccity") c.j2 = query.all()
Eg : 2
c.jo = Session.query(Address.city, Person.name).filter(Address.person_id==Person.id).all()