> Hi,

>   I have the model configured with belongsto association.

>   In this the query outputted looks like

>   SELECT `Firstpage`.`firstpagesid`, `Firstpage`.`imgnum`,
> `Firstpage`.`pageloc`, `Firstpage`.`desc_id`,
> `actressdesctbl`.`actressnum`, `actressdesctbl`.`actressfname`,
> `actressdesctbl`.`description`, `actressdesctbl`.`imgloc` FROM
> `firstpages` AS `Firstpage` INNER JOIN `actressdesctbls` AS
> `actressdesctbl` ON (`Firstpage`.`desc_id` = `actressdesctbl`.`id`)
> WHERE `firstpage`.`pageloc` = 1 ORDER BY `firstpage`.`imgnum` asc

>  The model association is listed below as well

> class firstpage extends AppModel {

>     public $name = 'firstpage';
>     public $belongsTo = array(
>         'actressdesctbl' => array(
>             'className'    => 'actressdesctbl',
>             'foreignKey'   => 'desc_id',
>             'type'         => 'INNER'
>         )
>     );
> }

>  Here the inner join is between desc_id in the firstpages table and
> the id in the actressdesctbl.  I dont want the inner join to default
> to id in the actressdesctbls.  Instead i have another column in the
> same table to which I need to join...Can I override the default...I
> dont want to use any prepared statement.

> Thanks for your help.

> Thanks
> padma Kumar

> On Feb 27, 11:01 am, jeremyharris <funeralm...@gmail.com> wrote:
> > It sounds like you should probably just include your own 'join' 'key[1]
> in
> > your find statement then.

> > 1:http://book.cakephp.org/1.3/en/view/1047/Joining-tables

> > On Sunday, February 26, 2012 4:15:18 PM UTC-8, padma wrote:

> > > Hi,

> > >   I have the model configured with belongsto association.

> > >   In this the query outputted looks like

> > >   SELECT `Firstpage`.`firstpagesid`, `Firstpage`.`imgnum`,
> > > `Firstpage`.`pageloc`, `Firstpage`.`desc_id`,
> > > `actressdesctbl`.`actressnum`, `actressdesctbl`.`actressfname`,
> > > `actressdesctbl`.`description`, `actressdesctbl`.`imgloc` FROM
> > > `firstpages` AS `Firstpage` INNER JOIN `actressdesctbls` AS
> > > `actressdesctbl` ON (`Firstpage`.`desc_id` = `actressdesctbl`.`id`)
> > > WHERE `firstpage`.`pageloc` = 1 ORDER BY `firstpage`.`imgnum` asc

> > >  The model association is listed below as well

> > > class firstpage extends AppModel {

> > >     public $name = 'firstpage';
> > >     public $belongsTo = array(
> > >         'actressdesctbl' => array(
> > >             'className'    => 'actressdesctbl',
> > >             'foreignKey'   => 'desc_id',
> > >             'type'         => 'INNER'
> > >         )
> > >     );
> > > }

> > >  Here the inner join is between desc_id in the firstpages table and
> > > the id in the actressdesctbl.  I dont want the inner join to default
> > > to id in the actressdesctbls.  Instead i have another column in the
> > > same table to which I need to join...Can I override the default...I
> > > dont want to use any prepared statement.

> > > Thanks for your help.

> > > Thanks
> > > padma Kumar- Hide quoted text -

> > - Show quoted text -

> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.

> To unsubscribe from this group, send email to
> cake-php+unsubscribe@googlegroups.com For more options, visit this group
> at http://groups.google.com/group/cake-php