Here's the code: // List gangs $c = new Criteria(); $c->addJoin(GangPeer::GANG_USER, UserPeer::ID, Criteria::LEFT_JOIN); $c->addJoin(GangPeer::GANG_COUNTRY, CountryPeer::ID); CountryPeer::addSelectColumns($c); $gangs = GangPeer::doSelect($c);