On Sep 28, 2:19 pm, Aivaras <faifas1...@gmail.com> 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 <saurabh85maha...@gmail.com> wrote:
>
> > 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....
>
>
Hi All,
Bad me, I think should have explained my problem properly.
Lets say following are the contents of my users table:
id | name | company id
1 | abc | 123
2 | def | 123
3 | ghi | 124
4 | jkl | 123
Now what I want is to retrieve, for a member (say 'abc') all the
people who are working in the same company.
Even though company_id is a foreign key, I am not interested in the
data of that table. What you suggested above is how to get the data
from the company table.
The simple sql query if I want all the members working in same company
as id = 2 would be:
SELECT B.* FROM `users` AS A LEFT JOIN `users` AS B
ON A.id = 2 where A.company_id = B.company_id
Since this includes JOIN with the table itself, I am not sure how to
achieve using Association Type.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
