title: Join query Symfony 1.4.11/Propel 1.4.2
body: <p>I've following query to execute</p>
  
  <pre><code>SELECT m.*, s.momento_idmember, sd.id_send, d.momento_id
  FROM `momento_send` s,
      `send_distribution` sd,
      `momento_distribution` d,
      `momento` m
  WHERE
      s.momento_idmember=6 AND
      sd.id_send=s.id AND
      sd.id_distribution=d.id AND
      d.momento_id=m.id;
  </code></pre>
  
  <p>MySQL 5.5.24 have proper relationship between tables.</p>
  
  <p>Can someone please suggest how to achieve this query through Criteria (or whatever best for that) in propel. I'm trying it since 2+ hours without success.</p>