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