Re: Self Join query

2009-09-29 Thread Bert Van den Brande
n den Brande > >wrote: >> > >> > > I would use the Containable behavior here, combined with a custom >> binding >> > > that you attach on the fly. >> > >> > > Have no idea however how exactly to expres a self-join binding ... try >

Re: Self Join query

2009-09-29 Thread Bert Van den Brande
to expres a self-join binding ... try > and > > > play around with it :) > > > > > On Mon, Sep 28, 2009 at 12:04 PM, hunny >wrote: > > > > >> On Sep 28, 2:19 pm, Aivaras wrote: > > >> > Hey, take a look at this: > > >>http

Re: Self Join query

2009-09-29 Thread hunny
e fly. > > > Have no idea however how exactly to expres a self-join binding ... try and > > play around with it :) > > > On Mon, Sep 28, 2009 at 12:04 PM, hunny wrote: > > >> On Sep 28, 2:19 pm, Aivaras wrote: > >> > Hey, take a look at this: > >&

Re: Self Join query

2009-09-28 Thread Bert Van den Brande
binding ... try and > play around with it :) > > > On Mon, Sep 28, 2009 at 12:04 PM, hunny wrote: > >> >> >> >> On Sep 28, 2:19 pm, Aivaras wrote: >> > Hey, take a look at this: >> http://voveris.eu/2009/09/05/left-join-with-cakephp/I am sure you

Re: Self Join query

2009-09-28 Thread Bert Van den Brande
varas wrote: > > Hey, take a look at this: > http://voveris.eu/2009/09/05/left-join-with-cakephp/I am sure you find > this > > handy. > > > > On Mon, Sep 28, 2009 at 12:04, hunny wrote: > > > > > Hi All, > > > > > I am new to cakephp. I would

Re: Self Join query

2009-09-28 Thread hunny
On Sep 28, 2:19 pm, Aivaras wrote: > Hey, take a look at > this:http://voveris.eu/2009/09/05/left-join-with-cakephp/I am sure you find > this > handy. > > On Mon, Sep 28, 2009 at 12:04, hunny wrote: > > > Hi All, > > > I am new to cakephp. I would lik

Re: Self Join query

2009-09-28 Thread Aivaras
Hey, take a look at this: http://voveris.eu/2009/09/05/left-join-with-cakephp/ I am sure you find this handy. On Mon, Sep 28, 2009 at 12:04, hunny wrote: > > Hi All, > > I am new to cakephp. I would like to execute the following SELF Join > query. > > SELECT B.* FROM `

Self Join query

2009-09-28 Thread hunny
Hi All, I am new to cakephp. I would like to execute the following SELF Join query. SELECT B.* FROM `users` AS A LEFT JOIN `users` AS B ON A.id = 2 where A.company_id = B.company_id Could some one guide or refer some tutorials, on how to achieve this in cake php. Thanks in advance