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
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