How to make this query below, with one of this association type:
hasOne, hasMany ,belongsTo, hasAndBelongsToMany ? Its just one simple
LEFT JOIN, but i cant figure out how to make it...

function getData() {
      $ret = $this->query("SELECT films.id, films.title, films.body,
films.pubdate, types.name as type ".
                          "FROM films films ".
                          "LEFT JOIN types types on
films.type=types.id ORDER by films.id DESC");
  return $ret;
}

--
RK

--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to