I have two tables details and users . I am getting the Detail.id from this i will be able to know User.id and then from users table i have to fetch user data like(name, email, etc). so i want to make query in cake pattern that in result should give me data of both the table. Here's simple query that i have made but couldnt get it going in cake pattern.
SELECT d.vps_name, d.machine_type, d.ipAddress, d.rdp_user,d.rdp_pass, d.dc_user, d.dc_pass, d.status, d.user_id, d.order_id,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 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
