/*

Query prototype

SELECT c.name
FROM products p
LEFT JOIN companies c ON c.id = p.company
WHERE p.category = 2
GROUP BY c.name

DQL:
*/

		$companies = Doctrine_Query::create() -> select("c.name")
                                          -> from("Product p")
                                          -> leftJoin("p.Company c")
                                          -> where("p.category = ?", $rd -> getParameter("id"))
                                          -> groupBy("c.name")
                                          -> execute();

/*

Catchable fatal error: Argument 1 passed to Doctrine_Hydrator_RecordDriver::getElement() must be an array, null given, called in C:\Server\www\tts\app\lib\model\doctrine\Doctrine\Hydrator.php on line 128 and defined in C:\Server\www\tts\app\lib\model\doctrine\Doctrine\Hydrator\RecordDriver.php on line 106

*/