title: symfony 1.4: How to fetch records from relation table
body: <p>How to get objects from the "many" table record?</p>
  
  <p>I have list of <code>rsObjectComments</code> and I need to fetch <code>rsObjects</code>.</p>
  
  <p>For example:</p>
  
  <p>schema.yml:
  </p>
  
  <pre><code>rsObject:
    actAs:
      Timestampable: ~ 
      Sluggable:
        fields: [name]
    columns:
      name: { type: string(255), notnull: true, unique: true }
      description:  { type: string(6000), notnull: true }
    relations:
      rsObjectComments:
       class:        rsObjectComments
       local:        id
       foreign:      rsobject_id
       type:         many
       foreignAlias: Comments
  
  rsObjectComments:
    actAs:
      Timestampable: ~
    columns:
      rsobject_id: { type: integer, notnull: true }
      fromname: { type: string(100), notnull:true }
      fromemail: { type: string(100), notnull:true }
      comments: { type: string(1000), notnull:true }    
      is_public: { type: boolean, notnull: true, default: 1 }
    relations:
      rsObject: { onDelete: CASCADE, local: rsobject_id, foreign: id, foreignAlias: rsObjectCommentsAlias } 
  </code></pre>