Chciałbym wykonać zapytanie w stylu:
SELECT u.*, c.name AS company_name FROM users LEFT JOIN company ON u.company_id = c.id
W sensie wszystkie pola uzytkownika + nazwa firmy
Próbowałem tak:
$criteria = new Criteria(); $criteria->addAlias("c", CompanyPeer::TABLE_NAME); $criteria->addAlias("u", UsersPeer::TABLE_NAME); $criteria->addJoin(UsersPeer::COMPANY_ID, CompanyPeer::ID, Criteria::LEFT_JOIN); $criteria->addSelectColumn("c.name as company_name"); $result = UsersPeer::doSelect($criteria);