title: Subquery in cakePHP to lookup in other table
body: <p>I recently started experimenting with CakePHP. I used this query in "normal" PHP and need to convert it to a CakePHP find. However I can't seem to make it work!</p>
  
  <pre><code>SELECT *, 
  (SELECT name FROM `users` WHERE `users`.`id`=`products`.`creator`) AS creatorname 
  FROM `products` 
  WHERE `products`.`ID`='2'
  </code></pre>
  
  <p>It's a basic set up with 2 tables, users and products. Every product gets created by a user and I need to load the name of the user along with the product info. (So I can display the username and not just the user id.</p>
  
  <p>Any thoughts?</p>