If you have write associations between the tables (in MODELS) cake does
the sql stament itself. But if you want to write your own query:
$query("SELECT `Version`.`id`, `Version`.`name` FROM `versions` AS
`Version` LEFT JOIN `softwares` AS `Software` ON
`Version`.`software_id` = `Software`.`id`")
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---