Re: [fw-db] Help with joins and integrity check

Thx Just what I needed, I should read the docs more sorry :)

2008/12/4 EducatedFool <wimkumpen@hotmail.com>:
>
> $select->from(array('p'=>'product'))
> ->joinLeft(array(cp'=>'category_product'),
> 'cp.productId = p.productId',
> array('field1','field2','...))
> ->where...
>
> the 3th parameter of the join is where you define your fields you want to
> select from the join table.
>
>
>
> keith Pope-4 wrote:
>>
>> Hi,
>>
>> How do you select columns in a join, I am trying to join using
>> setIntegrityCheck(true);
>>
>> $select = $this->select()->setIntegrityCheck(true);
>> $select->from(array('p' => 'product'))
>> ->joinLeft(array('cp' => 'category_product'),
>> 'cp.productId = p.productId')
>> ->where('cp.categoryId', $categoryId);
>>
>> gives:
>>
>> SELECT `p`.*, `cp`.* FROM `product` AS `p` LEFT JOIN
>> `category_product` AS `cp` ON cp.productId = p.productId WHERE
>> (cp.categoryId)
>>
>> But I don't want `cp`.* in the select so I can have integrity check true.
>>
>> Thx
>>
>> Keith
>>
>>
>
>
> -----
> http://www.phpscriptor.com/ http://www.phpscriptor.com/
> --
> View this message in context: http://www.nabble.com/Help-with-joins-and-integrity-check-tp20833562p20833646.html
> Sent from the Zend DB mailing list archive at Nabble.com.
>
>

--
----------------------------------------------------------------------
[MuTe]
----------------------------------------------------------------------