Re: fetch data from 2 tables through cake pattern

2010-01-20 Thread Ernesto
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

fetch data from 2 tables through cake pattern

2010-01-19 Thread John
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