I just added this to zend_db_select, it was easy to add, not sure why
only half of the things are supported ?
const NATURAL_LEFT_JOIN = 'natural left join';
public function joinLeftNatural($name, $cols = '*', $schema = null)
{
return $this->_join(self::NATURAL_LEFT_JOIN, $name, null,
$cols, $schema);
}
I dont really like to break or add things but oh well, maybe I could
extend it ?
On 06/09/2007, at 4:36 AM, Daniel Rossi wrote:
Hi, I was wondering if there is support for Natural Left Join
support for Zend Select ? Ive come across a problem, where ive
tried to reduce the sql on join conditions, but when using natural
join, i cant do a left join on one table it claims that the field
is ambigous because its the same field aswell, only natural left
join will work on that table.
Let me know.
