from wich controller are you fetching data?
users or details?
PS: i suggest you to follow cake's db conventions
On 19 Gen, 06:33, John sign.gro...@gmail.com wrote:
Hello
I have two tables that is users and details. i want to fetch data from
these 2 . i am getting details.id through which i have the whole row.
and in this row i have details.user_id and through this user_id i want
the row from users table.
SELECT d.*,u.email, u.fname, u.lname
FROM details as d
LEFT JOIN users as u
ON d.user_id = u.id
WHERE d.user_id = u.id
this is the simple query i want to make it through cake pattern but
find anything yet
Thanks in advance
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
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