how to do a subquery or filter in a condition met by a previous query correctly

result = db.session.query(model.Foo1, model.Foo2)\
         .join(model.Foo1, model.Foo1.id == model.Foo2.name_id)\
         .filter(model.Foo1.id != 2).all()